MyBlog
Tables (5)
Category
- its id (_id) — int — Primary key — NOT NULL
- category name (category_name) — varchar(32)
- visible — boolean — NOT NULL
- position — int
- CategoryGroup(_id) (its_group) — int — Foreign key → CategoryGroup.its id — NOT NULL
- post number (post_count) — int — NOT NULL
CategoryGroup
- its id (_id) — int — Primary key — NOT NULL
- group name (group_name) — varchar(32)
- visible — boolean — NOT NULL
- position — int
Post
- its id (_id) — int — Primary key — NOT NULL — auto_increment
- User(_id) (writer_id) — int — Foreign key → User.its id — NOT NULL
- Category(_id) (its_category) — int — Foreign key → Category.its id — NOT NULL
- post content (body) — varchar(10000) — NOT NULL — 포스트 내용
- post title (title) — varchar(255) — NOT NULL — 포스트 제목
- creation time (time) — datetime — NOT NULL
Role
- its id (_id) — int — Primary key — NOT NULL — PRIMARY KEY
- role name (role_name) — varchar(255) — Primary key — NOT NULL
- power — int
User
- its id (_id) — int — Primary key — NOT NULL — PRIMARY KEY
- username — varchar(255) — Primary key — NOT NULL
- Role(role_name) (its_role) — varchar(255) — Foreign key → Role.its id — NOT NULL
- user email (email) — varchar(255) — NOT NULL