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)