board
Tables (7)
category
- id — int — Primary key — NOT NULL
- name — varchar(45)
comment
- id — int — Primary key — NOT NULL
- postId — int — Foreign key → post.id — NOT NULL
- contents — varchar(300)
- subCommentId — int — Foreign key → comment.id — NOT NULL
file
- id — int — Primary key — NOT NULL
- postId — int — Foreign key → post.id — NOT NULL
- path — varchar(100)
- name — varchar(45)
- extenstion — varchar(45)
post
- id — int — Primary key — NOT NULL
- userId — int — Foreign key → user.id — NOT NULL
- categoryId — int — Foreign key → category.id — NOT NULL
- name — varchar(45)
- isAdmin — tinyint
- contents — varchar(300)
- createTime — datetime
- views — int
postTag
- id — int — Primary key — NOT NULL
- tagId — int — Foreign key → tag.id — NOT NULL
- postId — int — Foreign key → post.id — NOT NULL
tag
- id — int — Primary key — NOT NULL
- name — varchar(45)
- url — varchar(45)
user
- id — int — Primary key — NOT NULL
- userId — int
- password — varchar(45)
- nickname — varchar(45)
- isAdmin — tinyint
- createTime — dateTime
- isWithDraw — tinyint