erd

Tables (10)

Comment (Untitled4)

  • comment_id (Key) — int — Primary key — NOT NULL
  • freePost_id (Key2) — int — Foreign key → freePost.freePost_id — NOT NULL
  • user_id (Key3) — int — Foreign key → User.user_id — NOT NULL
  • content (Field) — varchar(100)

CommentLIke (Untitled9)

  • Key — int — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → User.user_id — NOT NULL
  • comment_id (Key3) — int — Foreign key → Comment.comment_id — NOT NULL

Community (CopyOfUntitled)

  • community_id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → User.user_id — NOT NULL
  • title (Field) — varchar(30)
  • body (Field2) — text
  • date (Field3) — date

Follow (Untitled7)

  • follow_id (Key) — int — Primary key — NOT NULL
  • following_id (Key2) — int — Foreign key → User.user_id — NOT NULL
  • follower_id (Key3) — int — Foreign key → User.user_id — NOT NULL

Hashtags (Untitled5)

  • hashtag_id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(30)

Image (Untitled3)

  • image_id (Key) — int — Primary key — NOT NULL
  • freePost_id (Key2) — int — Foreign key → freePost.freePost_id — NOT NULL
  • community_id (Key4) — int — Foreign key → Community.community_id — NOT NULL
  • src (Field) — varchar(200)

PostLIke (Untitled8)

  • like_id (Key) — int — Primary key — NOT NULL
  • freePost_id (Key2) — int — Foreign key → freePost.freePost_id — NOT NULL
  • user_id (Key3) — int — Foreign key → User.user_id — NOT NULL

Posthashtag (Untitled6)

  • posthashtag_id (Key3) — int — Primary key — NOT NULL
  • freePost_id (Key) — int — Foreign key → freePost.freePost_id — NOT NULL
  • hashtag_id (Key2) — int — Foreign key → Hashtags.hashtag_id — NOT NULL

User (Untitled2)

  • user_id (Key) — int — Primary key — NOT NULL
  • email (Field) — varchar(30)
  • id (Field2) — varchar(30)
  • password (Field3) — varchar(30)
  • nickname (Field5) — varchar(30)
  • question (Field6) — varchar(100)

freePost (Untitled)

  • freePost_id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → User.user_id — NOT NULL
  • title (Field) — varchar(30)
  • body (Field2) — text
  • date (Field3) — date
  • checkbox (Field5) — varchar(30)