개정판 e7ed3a04
issue #49: change table size
Change-Id: I9fb11792bf34a8c0035a21f0deb2f40df031ba9a
| DTI_PID/DTI_PID/Scripts/MSSQL/ID2.sql | ||
|---|---|---|
| 3155 | 3155 |
CREATE TABLE Dictionary ( |
| 3156 | 3156 |
UID VARCHAR (37) CONSTRAINT Dictionary_PK PRIMARY KEY |
| 3157 | 3157 |
NOT NULL, |
| 3158 |
Code VARCHAR (32) NOT NULL
|
|
| 3158 |
Code VARCHAR (128) NOT NULL
|
|
| 3159 | 3159 |
UNIQUE, |
| 3160 | 3160 |
Description TEXT, |
| 3161 | 3161 |
Allowables TEXT |
| ... | ... | |
| 3163 | 3163 | |
| 3164 | 3164 |
CREATE TABLE SymbolAttributeCodeTable ( |
| 3165 | 3165 |
UID VARCHAR(37) NOT NULL, |
| 3166 |
Code VARCHAR(32) NOT NULL,
|
|
| 3166 |
Code VARCHAR(128) NOT NULL,
|
|
| 3167 | 3167 |
Description TEXT, |
| 3168 | 3168 |
Allowables TEXT, |
| 3169 | 3169 |
SymbolAttribute_UID VARCHAR(37) NOT NULL, |
| ... | ... | |
| 3183 | 3183 |
CREATE TABLE CustomCodes ( |
| 3184 | 3184 |
UID VARCHAR ( 37 ) NOT NULL, |
| 3185 | 3185 |
Table_UID VARCHAR ( 37 ) NOT NULL, |
| 3186 |
Code VARCHAR ( 32 ) NOT NULL,
|
|
| 3186 |
Code VARCHAR ( 128 ) NOT NULL,
|
|
| 3187 | 3187 |
Description TEXT, |
| 3188 | 3188 |
Allowables TEXT, |
| 3189 | 3189 |
CONSTRAINT CustomCodes_PK PRIMARY KEY(UID), |
| ... | ... | |
| 3225 | 3225 |
CREATE TABLE InstCodes ( |
| 3226 | 3226 |
[UID] varchar ( 37 ) NOT NULL, |
| 3227 | 3227 |
Table_UID varchar ( 37 ) NOT NULL, |
| 3228 |
[Code] varchar ( 37 ),
|
|
| 3229 |
[Symbols] varchar ( 37 ),
|
|
| 3230 |
[Attribute] varchar ( 37 ),
|
|
| 3231 |
NewCode varchar ( 37 ) NOT NULL,
|
|
| 3228 |
[Code] varchar ( 128 ),
|
|
| 3229 |
[Symbols] varchar ( 128 ),
|
|
| 3230 |
[Attribute] varchar ( 128 ),
|
|
| 3231 |
NewCode varchar ( 128 ) NOT NULL,
|
|
| 3232 | 3232 |
[Expression] varchar ( 1024 ), |
| 3233 | 3233 |
[Priority] varchar ( 37 ), |
| 3234 | 3234 |
FOREIGN KEY(`Table_UID`) REFERENCES `InstTables`(`UID`), |
내보내기 Unified diff