lis_order

CREATE TABLE `lis_order` (
ÌD` BIGINT(20) NOT NULL AUTO_INCREMENT,

`MESSAGE_DT` DATETIME NULL DEFAULT NULL,
ÒRDER_CONTROL` ENUM('NW','RP','CA') NULL DEFAULT NULL COLLATE
'latin1_swedish_ci',
`PID` VARCHAR(15) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`PNAME` VARCHAR(40) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
ÀDDRESS1` VARCHAR(100) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`PTYPE` ENUM('IN','OP') NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`BIRTH_DT` DATE NULL DEFAULT NULL,
`SEX` ENUM('1','2') NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
ÒNO` VARCHAR(17) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`REQUEST_DT` DATETIME NULL DEFAULT NULL,
`SOURCE` VARCHAR(80) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`CLINICIAN` VARCHAR(80) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`ROOM_NO` VARCHAR(15) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`PRIORITY` ENUM('R','U') NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`COMMENT` VARCHAR(80) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`VISITNO` VARCHAR(17) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
ÒRDER_TESTID` VARCHAR(2000) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
`FLAG` ENUM('0','1') NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
PRIMARY KEY (ÌD`) USING BTREE,
UNIQUE INDEX ÒNO` (ÒNO`) USING BTREE
)
COLLATE='latin1_swedish_ci'
ENGINE=MyISAM
AUTO_INCREMENT=46607
;

lis_order

Uploaded by

Document Informationclick to expand document information

Copyright:

Available Formats

lis_order

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

lis_order

Uploaded by

Copyright:

Available Formats

CREATE TABLE `lis_order` (

`ID` BIGINT(20) NOT NULL AUTO_INCREMENT,

You might also like