GOTGONG

Tables (6)

Plan (계획)

  • plan_id (Key) — Lng — Primary key — NOT NULL
  • room_id (Key2) — Long — Foreign key → Room.room_id — NOT NULL
  • weekNum (Field) — Integer
  • dislike_count (Field2)
  • content (Field3) — varchar
  • plan_status (Field4) — Boolean
  • plan_dday (Field5) — date
  • study_dday (Field6) — date

Room (방)

  • room_id (Key) — Long — Primary key — NOT NULL
  • roomname (Field) — varchar
  • maxNum (Field2) — integer
  • targetDate (Field3) — Date
  • rule (Field4) — Boolean
  • entercode (Field5) — varchar
  • Field6

Untitled (측정)

  • Key — Primary key — NOT NULL
  • plan_id (Key2) — Lng — Foreign key → Plan.plan_id — NOT NULL
  • room_id (Key22) — Long — Foreign key → Plan.room_id — NOT NULL
  • self_check_perc (Field) — float
  • refund (Field2) — Integer

User (사용자)

  • user_id (Key) — Long — Primary key — NOT NULL
  • email (Field) — Email
  • password (Field2) — varchar
  • name (Field3) — varchar

UserRoom (사용자-방)

  • UserRoom (Key) — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → User.user_id — NOT NULL
  • room_id (Key3) — Long — Foreign key → Room.room_id — NOT NULL
  • leader_id (Field)

detail (할일)

  • detail_id (Key) — Long — Primary key — NOT NULL
  • plan_id (Key2) — Lng — Foreign key → Plan.plan_id — NOT NULL
  • room_id (Key22) — Long — Foreign key → Plan.room_id — NOT NULL
  • self_check (Field) — Boolean
  • content (Field2) — varchar
  • dislike_count (Field3) — Integer