RECRUIT

Tables (4)

TBL_APPLICANT (CopyOfUntitled)

  • uid (Key) — int — Primary key — NOT NULL
  • uname (Field2) — String — NOT NULL

TBL_APPLY (Untitled2)

  • uid (Key2) — int — Foreign key → TBL_APPLICANT.uid — NOT NULL
  • bno (Key) — int — Foreign key → TBL_BOARD.bno — NOT NULL
  • applyDate (Field) — date — NOT NULL

TBL_BOARD (Untitled)

  • bno (Key) — int — Primary key — NOT NULL
  • cid (Key2) — int — Foreign key → TBL_COMPANY.cid — NOT NULL
  • position (Field4) — String — NOT NULL
  • content (Field) — String
  • regDate (Field2) — date — NOT NULL
  • updateDate (Field3) — date

TBL_COMPANY (Untitled3)

  • cid (Key) — int — Primary key — NOT NULL
  • cname (Field) — String — NOT NULL