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