얼굴좀보자 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