얼굴좀보자 ERD

테이블 (9)

Room (room)

  • Key (room_id) — bigint(20) — 기본 키 — NOT NULL
  • Field (title) — varchar(255) — NOT NULL
  • Field2 (start_time) — datetime — NOT NULL
  • Field3 (password) — varchar(255) — NOT NULL
  • Field4 (url) — varchar(255) — NOT NULL
  • Field (people_num) — bigint(20) — NOT NULL
  • Key (host_id) — bigint(20) — 외래 키 → User.Key — NOT NULL

Untitled (message)

  • Key (message_id) — bigint(20) — 기본 키 — NOT NULL
  • Field (contents) — text — NOT NULL
  • Field (send_date) — datetime — NOT NULL

Untitled (user_message)

  • Key (user_message_id) — bigint(20) — 기본 키 — NOT NULL
  • Key (sender_id) — bigint(20) — 외래 키 → User.Key — NOT NULL
  • Key (receiver_id) — bigint(20) — 외래 키 → User.Key — NOT NULL
  • Key (message_id) — bigint(20) — 외래 키 → Untitled.Key — NOT NULL
  • Field (is_view) — bit(1) — NOT NULL

Untitled (friend)

  • Key (id) — bigint(20) — 기본 키 — NOT NULL
  • Key (user_id) — bigint(20) — 외래 키 → User.Key — NOT NULL
  • Key (friend_id) — bigint(20) — 외래 키 → User.Key — NOT NULL
  • Field (is_friend) — bit(1) — NOT NULL

Untitled (reservation)

  • Key (resetvation_id) — bigint(20) — 기본 키 — NOT NULL
  • Key (host_id) — bigint(20) — 외래 키 → User.Key — NOT NULL
  • Key (room_id) — bigint(20) — 외래 키 → Room.Key — NOT NULL
  • Field (reservation_time) — datetime — NOT NULL

Untitled (file)

  • Key (file_id) — bigint(20) — 기본 키 — NOT NULL
  • Key (room_id) — bigint(20) — 외래 키 → Room.Key — NOT NULL
  • Field (file_name) — varchar(255) — NOT NULL
  • Field (file_path) — varchar(255) — NOT NULL
  • Field (file_type) — varchar(255) — NOT NULL

Untitled (chat)

  • Key (chat_id) — bigint(20) — 기본 키 — NOT NULL
  • Key (room_id) — bigint(20) — 외래 키 → Room.Key — NOT NULL

Untitled (join_room)

  • Key (join_room_id) — bigint(20) — 기본 키 — NOT NULL
  • Key (user_id) — bigint(20) — 외래 키 → User.Key — NOT NULL
  • Key (room_id) — bigint(20) — 외래 키 → Room.Key — NOT NULL

User (user)

  • Key (user_id) — bigint(20) — 기본 키 — NOT NULL
  • Field (name) — varchar(255) — NOT NULL
  • Field (password) — varchar(255) — NOT NULL
  • Field (email) — varchar(255) — NOT NULL
  • Field (create_date) — datetime — NOT NULL
  • Field (state) — bit(1) — NOT NULL