server

테이블 (10)

Copy Of 회원 (user_agree)

  • Key (user_agree_id) — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → 회원.user_id — NOT NULL
  • Field (is_14_over) — tinyint(1) — NOT NULL
  • Field (accept_email_date) — datetime
  • Field (is_accept_today_noti) — tinyint(1) — NOT NULL
  • Field (is_accept_new_user_noti) — tinyint(1) — NOT NULL
  • Field (is_accept_done_noti) — tinyint(1) — NOT NULL
  • Field (is_accept_delete_noti) — tinyint(1) — NOT NULL

group (floor_group)

  • Key (group_id) — bigint — 기본 키 — NOT NULL
  • invite_code — varchar(10) — NOT NULL
  • Field (name) — varchar(10) — NOT NULL
  • Field (floor_type) — varchar(10) — NOT NULL

memeber (group_user)

  • Key (group_user_id) — bigint — 기본 키 — NOT NULL
  • group_id — bigint — 외래 키 → group.Key — NOT NULL
  • user_id — bigint — 외래 키 → 회원.user_id — NOT NULL
  • role — varchar(10) — NOT NULL

notification

  • notification_id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → 회원.user_id — NOT NULL
  • Key (group_id) — bigint — 외래 키 → group.Key — NOT NULL
  • Field (title) — varchar(100)
  • Field (content) — varchar(255)

그룹 내 방 정보 (room)

  • Key (room_id) — bigint — 기본 키 — NOT NULL
  • group_id — bigint — 외래 키 → group.Key — NOT NULL
  • Field (size_x) — int — NOT NULL
  • Field (size_y) — int — NOT NULL
  • Field (location_x) — int — NOT NULL
  • Field (location_y) — int — NOT NULL
  • 방/거실 (room_type) — int — NOT NULL
  • Field (name) — varchar(10) — NOT NULL

기본 제공 가구 (furniture(default))

  • Key (furniture_id) — bigint — 기본 키 — NOT NULL
  • Field (size_x) — int — NOT NULL
  • Field (size_y) — int — NOT NULL
  • Field (name) — varchar(10) — NOT NULL
  • Field (img_key) — varchar(255)

방 내 가구 정보 (room_furniture)

  • Key (room_furn_id) — bigint — 기본 키 — NOT NULL
  • Key (furniture_id) — bigint — 외래 키 → 기본 제공 가구.Key — NOT NULL
  • Key (room_id) — bigint — 외래 키 → 그룹 내 방 정보.Key — NOT NULL
  • name (location_x) — int — NOT NULL
  • type_id (location_y) — int — NOT NULL
  • Field (rotation) — int — NOT NULL

집안일 (chore)

  • chores_id (chore_id) — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → 회원.user_id — NOT NULL
  • Key (room_furn_id) — bigint — 외래 키 → 방 내 가구 정보.Key — NOT NULL
  • Key (group_id) — bigint — 외래 키 → group.Key — NOT NULL
  • Field (name) — varchar(20) — NOT NULL
  • date (start_date) — datetime — NOT NULL
  • repetition — varchar(10)
  • last_date — datetime
  • Field (is_accept_noti) — tinyint(1) — NOT NULL

집안일 기록 (chore_log)

  • Key (chore_log_id) — bigint — 기본 키 — NOT NULL
  • chores_id (chore_id) — bigint — 외래 키 → 집안일.chores_id — NOT NULL
  • Field (isComplete) — tinyint(1)

회원 (user)

  • user_id — bigint — 기본 키 — NOT NULL
  • Field (email) — varchar(100) — NOT NULL
  • Field (nickname) — varchar(10) — NOT NULL
  • Field (gender) — varchar(10)
  • Field (birth) — date
  • Field (img_key) — varchar(255)
  • Field (provider) — varchar(10) — NOT NULL