ㅁㄴㅇㄹ
Tables (6)
Copy Of chat_invited_user (CopyOfchat_invited_user)
- message_id (invite_id) — int — Primary key — NOT NULL
- room_id (room_id2) — int — Foreign key → chat_room.room_id — NOT NULL
chat_invited_user
- invite_id — int — Primary key — NOT NULL
- room_id — int — NOT NULL
- invite_user — varchar(20) — NOT NULL
chat_room
- room_id — int — Primary key — NOT NULL
- room_name — varchar(100) — NOT NULL
hwet_board
- board_id — int — Primary key — NOT NULL
- writer — varchar(20) — Foreign key → user_info.user_id — NOT NULL
- title — varchar(50) — NOT NULL
- category — varchar(50) — NOT NULL
- link — varchar(400) — NOT NULL
- content — varchar(1000) — NOT NULL
- created_at — datetime — NOT NULL
- hit — int — NOT NULL
- updated_at — datetime
hwet_board_reply
- reply_id — int — Primary key — NOT NULL
- board_id — int — Foreign key → hwet_board.board_id — NOT NULL
- writer — varchar(20) — NOT NULL
- writer_nick — varchar(40) — NOT NULL
- created_at — datetime
- updated_at — datetime
- content — varchar(3000)
- positive_count — int
- negative_count — int
user_info
- user_id — varchar(20) — Primary key — NOT NULL
- user_pw — varchar(16) — NOT NULL
- user_name — varchar(20)
- user_birth — date
- user_nickname — varchar(40)
- user_gender — enum('남성','여성')
- user_tlno — varchar(20)
- user_joindate — date