ChatCampus

Tables (5)

alarms (alrams)

  • alarm_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • content — VARCHAR(50)
  • created_at — TIMESTAMP

chatrooms

  • chatroom_id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(50)

chatters

  • chatroom_id (chatroom_id2) — BIGINT — Foreign key → chatrooms.chatroom_id — NOT NULL
  • chatroom_id — BIGINT
  • user_id — BIGINT

chattings

  • chatting_id — BIGINT — Primary key — NOT NULL
  • chatroom_id — BIGINT — Foreign key → chatrooms.chatroom_id — NOT NULL
  • user_id (user_id2) — BIGINT — Foreign key → users.user_id — NOT NULL
  • user_id — BIGINT
  • content — TEXT
  • created_at (created_atd) — TIMESTAMP
  • state — ENUM('OK', 'DELETED')
  • chatroom_id (chatrood_id) — BIGINT

users

  • user_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(10)
  • email — VARCHAR(100)
  • password — VARCHAR(300)