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)