dbsession-standard

Tables (3)

Comment

  • id — integer — Primary key — NOT NULL
  • post_id (post) — integer — Foreign key → Post.writer — NOT NULL
  • user_id (외래2) — integer — Foreign key → User.id — NOT NULL
  • content — text

Post

  • id — integer — Primary key — NOT NULL
  • writer — integer — Foreign key → User.id — NOT NULL
  • title — varchar
  • content — text
  • category — varchar
  • created_at — timestamp
  • updated_at — timestamp

User

  • id — integer — Primary key — NOT NULL
  • username — varchar
  • email — varchar