1234
Tables (7)
comment
- comments_id — int — Primary key — NOT NULL
- post_id — int — NOT NULL
- user_id — int — NOT NULL
- parent_id — int — NOT NULL
- content — text — NOT NULL
- depth — int — NOT NULL
- anonymity — boolean — NOT NULL
- deleted — boolean — NOT NULL
- created_at — datetime — NOT NULL
policy
- policies_id — int — Primary key — NOT NULL
- regions_id — int — NOT NULL
- title — varchar(200) — NOT NULL
- content — VARCHAR(255) — NOT NULL
post
- post_id — int — Primary key — NOT NULL
- user_id — int — NOT NULL
- title — varchar(100) — NOT NULL
- content — text — NOT NULL
- anonymity — boolean — NOT NULL
- deleted — boolean — NOT NULL
- created_at — datetime — NOT NULL
- view_count — int — NOT NULL
post_like
- like_id — int — Primary key — NOT NULL
- post_id — int — Foreign key → post.post_id — NOT NULL
- user_id — int — NOT NULL
- reaction_type — int — NOT NULL
region
- region_id — int — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
report
- reports_id — int — Primary key — NOT NULL
- user_id — int — Foreign key → user.user_id — NOT NULL
- post_id — int — NOT NULL
- status — int — NOT NULL
- created_at — datetime — NOT NULL
user
- user_id — int — Primary key — NOT NULL
- regions_id — int — NOT NULL
- login_id — varchar(100) — NOT NULL
- email — varchar(100) — NOT NULL
- password — varchar(255) — NOT NULL
- nickname — varchar(50) — NOT NULL
- role — int — NOT NULL
- birth_year — int — NOT NULL
- gender — int — NOT NULL
- provider_type — varchar(20)
- created_at — datetime — NOT NULL