bb

Tables (6)

Comment

  • commentIdx — int — Primary key — NOT NULL
  • postIdx — int — Foreign key → Post.postIdx — NOT NULL
  • userIdx — int — Foreign key → User.userIdx — NOT NULL
  • content — varchar(100)
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar(10)

Post

  • postIdx — int — Primary key — NOT NULL
  • userIdx — int — Foreign key → User.userIdx — NOT NULL
  • Field (title) — varchar(50)
  • content — varchar(500)
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar(10)

Untitled (Like)

  • Key (likeIdx) — int — Primary key — NOT NULL
  • postIdx — int — Foreign key → Post.postIdx — NOT NULL
  • userIdx — int — Foreign key → User.userIdx — NOT NULL
  • Field (createdAt) — timestamp
  • Field (updatedAt) — timestamp
  • Field (status) — varchar(10)

Untitled (Level)

  • Key (levelIdx) — int — Primary key — NOT NULL
  • userIdx — int — Foreign key → User.userIdx — NOT NULL
  • Field (level) — varchar(0)

Untitled (DoubleComment)

  • Key (DCommentIdx) — int — Primary key — NOT NULL
  • commentIdx — int — Foreign key → Comment.commentIdx — NOT NULL
  • Key (levelIdx) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (content) — varchar(100)
  • Field (createdAt) — timestamp
  • Field (updatedAt) — timestamp
  • Field (status) — varchar(10)

User

  • userIdx — int — Primary key — NOT NULL
  • name — varchar(15)
  • id — varchar(15)
  • pwd — varchar(20)
  • createdAt — timestamp
  • updatedAt — timestamp
  • status — varchar(10)