contract

테이블 (5)

base_entity(모든 테이블이 공통적으로 가지는 속성 (Untitled4)

  • created_date (Field) — LOCALDATETIME
  • last_modified_date (Field2) — LOCALDATETIME

contract (Untitled2)

  • contrat_id (PK) — LONG — 기본 키 — NOT NULL
  • member_id (FK) — LONG — 외래 키 → member.member_id — NOT NULL
  • contract_type (계약 종류) — ENUM
  • legality (Field) — ENUM

contract type(table x) (Untitled3)

  • PROPERTY (Field) — STRING
  • EMPLOYMENT (Field2) — STRING

legality(table x) (Untitled5)

  • LEGAL (Field) — STRING
  • DANGER (Field2) — STRING
  • ILLEGAL (Field3) — STRING

member (Untitled)

  • member_id (PK) — LONG — 기본 키 — NOT NULL
  • account_email (Field) — STRING
  • password (Field2) — STRING
  • nickname (Field3) — STRING
  • is_kakao_member (Field6) — BOOLEAN
  • kakao_id (Field7) — LONG
  • birthday (Field4) — LOCALDATE