week09
Tables (5)
checklist (체크리스트)
- checklist_id (Key) — Long — Primary key — NOT NULL
- process_id (Key2) — Long — Foreign key → process.process_id — NOT NULL
- contractid (Key22) — Long — Foreign key → process.contractid — NOT NULL
- userid (Key222) — Long — Foreign key → process.userid — NOT NULL
- is_check (Field) — Boolean
- title (Field2) — String
- article (Field3) — String
contract (계약서)
- contractid (Key) — Long — Primary key — NOT NULL
- userid (Key2) — Long — Foreign key → user.userid — NOT NULL
- image (Field) — Long
- location (Field2) — String
process (계약 진행 프로세스)
- process_id (Key) — Long — Primary key — NOT NULL
- contractid (Key2) — Long — Foreign key → contract.contractid — NOT NULL
- userid (Key22) — Long — Foreign key → contract.userid — NOT NULL
- process_level (Field) — ENum
report (리포트)
- report_id (Key) — Long — Primary key — NOT NULL
- contractid (Key2) — Long — Foreign key → contract.contractid — NOT NULL
- userid (Key22) — Long — Foreign key → contract.userid — NOT NULL
- contract_report (Field4) — String
- ai_report (Field2) — String
- warnning (Field3) — String
user (사용자)
- userid (Key) — Long — Primary key — NOT NULL
- name (Field) — String
- profile_img (Field3) — String
- level (Field2) — Int