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)