instagram_clone

Tables (6)

Comment

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → Member.id — NOT NULL
  • post_id — BIGINT — Foreign key → Post.id — NOT NULL
  • content — varchar(200
  • create_date — datetime

Follow

  • id — BIGINT — Primary key — NOT NULL
  • from_member_id — BIGINT — Foreign key → Member.id — NOT NULL
  • to_member_id — varchar(10)
  • create_date — datetime

Like

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → Member.id — NOT NULL
  • post_id — BIGINT — Foreign key → Post.id — NOT NULL

Member

  • id — BIGINT — Primary key — NOT NULL
  • email — varchar(30)
  • name — varchar(10)
  • password — varchar(100)
  • profile_URL — varchar(200)
  • tatus_Message (status_message) — varchar(100)
  • create_date — datetime

Post

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → Member.id — NOT NULL
  • content — varchar(200)
  • create_date — datetime

Reply

  • id — BIGINT — Primary key — NOT NULL
  • comment_id — BIGINT — Foreign key → Comment.id — NOT NULL
  • post_id — BIGINT — Foreign key → Comment.post_id — NOT NULL
  • member_id — BIGINT — Foreign key → Member.id — NOT NULL
  • content — varchar(200)