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