헬프로미스

테이블 (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