LikeLion

Tables (5)

Comment (Untitled3)

  • id (comment_id) — Primary key — NOT NULL
  • content (comment_content) — char(200)
  • id (member_id) — Foreign key → Member.id — NOT NULL
  • id (post_id) — char — Foreign key → Post.id — NOT NULL

Member (Untitled2)

  • id (member_id) — Primary key — NOT NULL
  • name (member_name) — char(20)
  • email (member_email)

Post (Untitled)

  • id (post_id) — char — Primary key — NOT NULL
  • title (post_title) — char(50)
  • content (post_content) — char
  • create_at (post_create_at)
  • id (member_id) — Foreign key → Member.id — NOT NULL

User (Untitled4)

  • Key — Primary key — NOT NULL

UserPost (Untitled5)

  • Key — Primary key — NOT NULL
  • id (post_id) — char — Foreign key → Post.id — NOT NULL
  • Key (Key2) — Foreign key → User.Key — NOT NULL