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