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