개정판 2a074ac0
issue #663:
- upload TitleBlockValues.sql
DTI_PID/DTI_PID/Scripts/TitleBlockValues.sql | ||
---|---|---|
1 |
CREATE TABLE IF NOT EXISTS TitleBlockValues ( |
|
2 |
UID TEXT PRIMARY KEY, |
|
3 |
Drawings_UID TEXT REFERENCES Drawings (UID), |
|
4 |
TitleBlockProperties_UID TEXT REFERENCES TitleBlockProperties (UID), |
|
5 |
VALUE TEXT |
|
6 |
); |
|
7 |
CREATE UNIQUE INDEX IF NOT EXISTS [TitleBlockValues_UNIQUE_IDX] ON [TitleBlockValues]([Drawings_UID],[TitleBlockProperties_UID]); |
내보내기 Unified diff