ct

Tables (7)

BoardCategory (게시판상위카테고리)

  • category_id — int — Primary key — NOT NULL
  • name — string
  • label — string
  • description — string

BoardSubCategory (게시판하위카테고리)

  • subcategory_id — int — Primary key — NOT NULL
  • category_id (category_id2) — int — Foreign key → BoardCategory.category_id — NOT NULL
  • name — string
  • label — string
  • description — string
  • Field

Comment (댓글)

  • comment_id — int — Primary key — NOT NULL
  • post_id — int — Foreign key → Post.post_id — NOT NULL
  • user_id — int — Foreign key → Post.user_id — NOT NULL
  • content — string

Post (게시글)

  • post_id — int — Primary key — NOT NULL
  • subcategory_id — int — Foreign key → BoardSubCategory.subcategory_id — NOT NULL
  • user_id — int — Foreign key → User.user_id — NOT NULL
  • title — string
  • content — json
  • created_at — datetime
  • updated_at — datetime

PostTag (게시글 태그)

  • tag_id — int — Foreign key → Tag.tag_id — NOT NULL
  • post_id — int — Foreign key → Post.post_id — NOT NULL

Tag (태그)

  • tag_id — int — Primary key — NOT NULL
  • name — string

User (유저)

  • user_id — int — Primary key — NOT NULL
  • username — str
  • email — str
  • roles — str
  • created_at — datetime
  • updated_at — datetime