testdb

Tables (6)

chat (CHAT)

  • id — INT — Primary key — NOT NULL
  • chatroom_id — INT — Foreign key → chatroom_member.chatroom_id — NOT NULL
  • user_id — INT — Foreign key → chatroom_member.user_id — NOT NULL
  • content — VARCHAR(1000) — NOT NULL
  • create_dt — DATETIME — NOT NULL
  • update_dt — DATETIME — NOT NULL

chatroom (CHATROOM)

  • id — INT — Primary key — NOT NULL
  • user_count — INT — NOT NULL
  • create_dt — DATETIME — NOT NULL
  • update_dt — DATETIME — NOT NULL

chatroom_member (CHATROOM_MEMBER)

  • chatroom_id — INT — Foreign key → chatroom.id — NOT NULL
  • user_id — INT — Foreign key → user.id — NOT NULL
  • create_dt — DATETIME — NOT NULL
  • update_dt — DATETIME — NOT NULL

friend (FRIEND)

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.id — NOT NULL
  • friend_id — INT — Foreign key → user.id — NOT NULL
  • create_dt — DATETIME — NOT NULL
  • update_dt — DATETIME — NOT NULL

user (USER)

  • id — INT — Primary key — NOT NULL
  • status — ENUM — NOT NULL — active,deactive
  • name — VARCHAR(10) — NOT NULL
  • email — VARCHAR(30) — NOT NULL — ID 역할
  • password — CHAR(72) — NOT NULL
  • create_dt — DATETIME — NOT NULL
  • update_dt — DATETIME — NOT NULL
  • delete_dt — DATETIME — 유저 삭제 시 삭제 일시 기록

user_profile (USER_PROFILE)

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.id — NOT NULL
  • nick — VARCHAR(12) — NOT NULL
  • phone_num — VARCHAR(15) — NOT NULL
  • gender — CHAR(1) — NOT NULL
  • image_url — VARCHAR(500)
  • background_url — VARCHAR(500)