StackOverflow
Tables (6)
Body
- body_id — notNull — Primary key — NOT NULL
- cont_id — notNull — Foreign key → Content.content_id — NOT NULL — 양방향 다대일(관계 주인)
- user_id — notNull — Foreign key → User.user_id — NOT NULL
- parent_id — notNull
- body_kind — notNull
- text — notNull
- vote — Nullable
Content
- content_id — notNull — Primary key — NOT NULL
- content_kind — notNull — preview, specific
- title — notNull
- viewed — notNull
- answer_count — notNull — NOT NULL
Tag
- tag_id — notNull — Primary key — NOT NULL
- tag_name — notNull
- tag_discription — notNull
- taged_count — notNull
TimeCheck
- asked_at — notNull
- modified_at — notNull
Untitled (Tag_Content)
- content_id — notNull — Foreign key → Content.content_id — NOT NULL
- tag_id — notNull — Foreign key → Tag.tag_id — NOT NULL
User
- user_id — notNull — Primary key — NOT NULL
- username — notNull
- email — notNull
- role — notNull
- password — notNull