java팀플
테이블 (5)
ban_user (Untitled5)
- ban_user_id (Key) — bigint(20)_ — 기본 키 — NOT NULL
- banned_user_id (Key3) — bigint(20) — 외래 키 → users.user_id — NOT NULL
- reporter_id (Key2) — bigint(20) — 외래 키 → users.user_id — NOT NULL
- banned_date (Field) — datetime — NOT NULL
- reason (Field2) — varchar(255) — NOT NULL
- status (Field3) — varchar(20) — NOT NULL
chat_room (Untitled2)
- chat_room_id (Key) — bigint(20) — 기본 키 — NOT NULL
- name (Field2) — varchar(255) — NOT NULL
- created_date (Field) — datetime — NOT NULL
message (Untitled4)
- message_id (Key) — bigint(20) — 기본 키 — NOT NULL
- chat_room_id (Key2) — bigint(20) — 외래 키 → chat_room.chat_room_id — NOT NULL
- sender_id (Key3) — bigint(20) — 외래 키 → users.user_id — NOT NULL
- reciever_id (Key4) — bigint(20) — 외래 키 → users.user_id — NOT NULL
- content (Field) — text — NOT NULL
- created_date (Field2) — datetime — NOT NULL
- status (Field3) — varchar(20) — NOT NULL
user_chat_room (Untitled3)
- user_chat_room_id (Key) — bigint(20) — 기본 키 — NOT NULL
- user_id (Key2) — bigint(20) — 외래 키 → users.user_id — NOT NULL
- chat_room_id (Key3) — bigint(20) — 외래 키 → chat_room.chat_room_id — NOT NULL
- status (Field) — varchar(20) — NOT NULL
users (Untitled)
- user_id (Key) — bigint(20) — 기본 키 — NOT NULL
- account_id (Field7) — varchar(255) — NOT NULL
- password (Field2) — varchar(255) — NOT NULL
- username (Field) — varchar(255) — NOT NULL
- age (Field3) — bigint(20) — NOT NULL
- introduce (Field4) — varchar(255) — NOT NULL
- profile_image (Field5) — varchar(255) — NOT NULL
- gender (Field6) — varchar(20) — NOT NULL