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