Beomeo_wiki
Tables (4)
post (Untitled2)
- post_id (Primary Key) — INT — Primary key — NOT NULL
- user_id (Foreign Key) — INT — Foreign key → user.유저 id — NOT NULL
- post_title (Field) — VARCHAR(50)
- post_tag (Field2) — INT
- post_content (Field4) — VARCHAR(5000)
- updated_at (Field3) — DATE
post_history (Untitled4)
- history_id (Primary Key) — Integer — Primary key — NOT NULL
- user_id (Foreign Key2) — Integer — Foreign key → user.유저 id — NOT NULL
- post_id (Primary Key2) — INT — Foreign key → post.post_id — NOT NULL
- content_before (Field) — VARCHAR(5000)
- content_after (Field2) — VARCHAR(5000)
- content_diff (Field3) — VARCHAR(5000)
- modified_at (Field4) — DATE
report (Untitled3)
- report_id (Key) — Integer — Primary key — NOT NULL
- report_content (Field) — VARCHAR(500)
- report_type (Field2) — VARCHAR(20)
- user_id (Primary Key) — INT — Foreign key → user.유저 id — NOT NULL
- post_id (Primary Key2) — INT — Foreign key → post.post_id — NOT NULL
user (Untitled)
- 유저 id (user_id) — INT — Primary key — NOT NULL
- 이름 (username) — VARCHAR(50)
- 메일 (mail) — VARCHAR(50)
- 비밀번호 (password) — VARCHAR(20)
- created_at (Field3) — DATE