hana

Tables (4)

LIKE (Like)

  • ID (Id) — int — Primary key — NOT NULL
  • 유저 아이디 (user_id) — int — Foreign key → User.유저 아이디 — NOT NULL
  • postid (postId) — int — NOT NULL
  • liked — boolean — NOT NULL
  • postid (postId2) — int — Foreign key → Post.postid — NOT NULL
  • cID (cId2) — int — Foreign key → Post.cID — NOT NULL

Post

  • postid (postId) — int — Primary key — NOT NULL
  • cID (cId2) — int — Foreign key → category.cID — NOT NULL
  • userid (userId) — int — NOT NULL
  • title — varchar(60) — NOT NULL
  • content — text — NOT NULL
  • createDt — timestamp — NOT NULL
  • updateDt — timestamp — NOT NULL
  • cId — int — NOT NULL
  • 유저 아이디 (user_id) — int — Foreign key → User.유저 아이디 — NOT NULL

User

  • 유저 아이디 (user_id) — int — Primary key — NOT NULL
  • name — varchar(31) — NOT NULL
  • email — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • nickname — varchar(31) — NOT NULL
  • isAdmin — boolean — NOT NULL

category

  • cID (cId) — int — Primary key — NOT NULL
  • category — varchar(31) — NOT NULL