kimth_lab

테이블 (5)

company (Untitled3)

  • id (Key) — int — 기본 키 — NOT NULL
  • company_name (Field) — VARCHAR
  • company_address (Field2) — VARCHAR

crew (Untitled)

  • id (Key) — int — 기본 키 — NOT NULL
  • company_id (Key2) — int — 외래 키 → company.id — NOT NULL
  • email (Field2) — VARCHAR
  • password (Field7) — VARCHAR
  • name (Field) — VARCHAR
  • number (Field3) — VARCHAR
  • classification (Field4) — VARCHAR
  • role (Field8) — ENUM(SERVICE_ADMIN, COMPANY_ADMIN, MEMBER, GUEST)
  • is_authorized (Field9) — boolean

memo(임시) (Untitled4)

  • id (Key) — int — 기본 키 — NOT NULL
  • project_id (Key22) — int — 외래 키 → project.company_id — NOT NULL
  • content (Field) — VARCHAR
  • type (Field2) — ENUM(?, ?, ?)

participants (Untitled2)

  • id (Key) — int — 기본 키 — NOT NULL
  • project_id (Key22) — int — 외래 키 → project.company_id — NOT NULL
  • crew_id (Field2) — VARCHAR
  • project_role (Field) — ENUM(MANAGER, NORMAL)

project (CopyOfUntitled2)

  • id (Key) — int — 기본 키 — NOT NULL
  • company_id (Key2) — int — 외래 키 → company.id — NOT NULL
  • name (Field6) — VARCHAR
  • manager_id (Field10) — int
  • process_rate (Field) — int
  • start_date (Field2) — DATE
  • end_date (Field3) — DATE
  • construction_class (Field4) — VARCHAR
  • detail_construction_class (Field5) — VARCHAR
  • floor_plan (Field8) — VARCHAR
  • thumbnail_url (Field9) — VARCHAR