헬프로미스
테이블 (10)
alarm (Untitled8)
- alarm_id (Key) — 기본 키 — NOT NULL
- from_user_id (Key2) — 외래 키 → user.user_id — NOT NULL
- to_user_id (Field2)
- content (Field3)
board (Untitled4)
- board_id (Key) — 기본 키 — NOT NULL
- user_id (Key2) — 외래 키 → user.user_id — NOT NULL
- department_id (Key3) — 외래 키 → department.department_id — NOT NULL
- title (Field)
- content (Field2)
- tag (Field3)
department (Untitled5)
- department_id (Key) — 기본 키 — NOT NULL
- name (Field)
department_group (Untitled12)
- dg_id (Key) — 기본 키 — NOT NULL
- department_id (Key2) — 외래 키 → department.department_id — NOT NULL
- user_id (Key3) — 외래 키 → user.user_id — NOT NULL
department_public_tag (Untitled10)
- dpt_id (Key2) — 기본 키 — NOT NULL
- department_id (Key) — 외래 키 → department.department_id — NOT NULL
- user_id (Key3) — 외래 키 → user.user_id — NOT NULL
- tag (Field)
department_schedule (Untitled13)
- ds_id (Key) — 기본 키 — NOT NULL
- department_id (Key2) — 외래 키 → department.department_id — NOT NULL
- schedule_id (Key3) — 외래 키 → schedule.schedule_id — NOT NULL
favorite_user (Untitled9)
- fu_id (Key) — 기본 키 — NOT NULL
- from_user_id (Key2) — 외래 키 → user.user_id — NOT NULL
- to_user_id (Field)
schedule (Untitled2)
- schedule_id (Key) — 기본 키 — NOT NULL
- title (Field2)
- content (Field3)
- start_datetime (Field)
- end_datetime (Field4)
- isCompleted (Field5)
- location (Field6)
- repeat (Field7)
user (Untitled)
- user_id (Key) — 기본 키 — NOT NULL
- name (Field)
- email (Field2)
- birthday (Field3)
- phone_number (Field4)
user_schedule ( group) (Untitled3)
- group_id (Key3) — 기본 키 — NOT NULL
- user_id (Key) — 외래 키 → user.user_id — NOT NULL
- schedule_id (Key2) — 외래 키 → schedule.schedule_id — NOT NULL