CreateWorkBook
Tables (4)
userlist (Untitled)
- userid (Key) — varchar — Primary key — NOT NULL
- userpw (Field) — varchar
- username (Field2) — varchar
work1 (Untitled2)
- work1id (Key) — int — Primary key — NOT NULL
- userid (Key2) — varchar — Foreign key → userlist.userid — NOT NULL
- work1title (Field) — varchar
- workdate (Field2) — varchar
- publ (Field3) — varchar
- cli (Field4)
work2 (Untitled3)
- work2id (Key3) — int — Primary key — NOT NULL
- work1id (Key) — int — Foreign key → work1.work1id — NOT NULL
- userid (Key2) — varchar — Foreign key → work1.userid — NOT NULL
- work2_qs (Field) — varchar
- work2_view1 (Field2) — varchar
- work2_view2 (Field3) — varchar
- work2_view3 (Field4) — varchar
- work2_view4 (Field5) — varchar
- work2_value (Field6) — varchar
wrong (Untitled4)
- userid (Key) — varchar — Foreign key → userlist.userid — NOT NULL
- wrong (Field2) — int