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