clean-chat

Tables (5)

chat_contents

  • id — int — Primary key — NOT NULL
  • content — text
  • image_path — varchar(30)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • chat_list_id — int — Foreign key → chat_lists.id
  • user_id — int — Foreign key → users.id
  • deleted — tinyint(1)

chat_lists

  • id — int — Primary key — NOT NULL
  • group — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

chat_users

  • id — int — Primary key — NOT NULL
  • chat_title — varchar(50)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime
  • user_id — int — Foreign key → users.id
  • chat_list_id — int — Foreign key → chat_lists.id

friends

  • user_id — int — Foreign key → users.id — NOT NULL
  • friend_id — int — Foreign key → users.id — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

users

  • id — int — Primary key — NOT NULL
  • email — varchar(20) — NOT NULL
  • password — varchar(100) — NOT NULL
  • name — varchar(10) — NOT NULL
  • gender — enum('M','F','X') — NOT NULL
  • image_path — varchar(30) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime