asd
Tables (6)
Tag
- tagid — TINYINT — Primary key — NOT NULL
- Tagname — VARCHAR(20) — 직업
User
- id — INT — Primary key — NOT NULL
- email — VARCHAR(50)
- name — VARCHAR(10)
- user_id — VARCHAR(20)
- password — VARCHAR(255)
- nickname — VARCHAR(10)
- created_at — DATETIME
- updated_at — DATETIME
- user_type — TINYINT — 0: 일반유저 1: 전문가 2: 어드민
- grade — TINYINT
- produce — VARCHAR(500) — 전문가
- picture — IMG
- job — VARCHAR(255) — 전문가
UserTag
- user_id — INT — Foreign key → User.id — NOT NULL
- tagid — TINYINT — Foreign key → Tag.tagid — NOT NULL
board
- id — INT — Primary key — NOT NULL
- title — VARCHAR(30)
- content — TEXT
- view_cnt — INT
- comment_cnt — INT
- like_cnt — INT
- created_at — DATETIME
- updated_at — DATETIME
chat
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → User.id — NOT NULL
- startchat_at — DATETIME
- endchat_at — DATETIME
- content — VARCHAR(1000)
- chat_status — INT — 0: 양쪽 부재, 1: 한명만 있음, 2: 둘다 있음
comment
- id — INT — Primary key — NOT NULL
- board_id — INT — Foreign key → board.id — NOT NULL
- content — VARCHAR(300)
- like_cnt — INT
- comment_at — DATETIME
- update_at — DATETIME