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