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