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