SNS
Tables (8)
Comment (Untitled3)
- coment_id (PK) — int — Primary key — NOT NULL
- member_id (PK2) — int — Foreign key → Memeber.member_id — NOT NULL
- post_id (PK3) — int — Foreign key → Post.post_id — NOT NULL
- Follow_id (PK223) — int — Foreign key — NOT NULL
- comment_contents (Field) — String
- Field2
Follow (Untitled5)
- follower_id (PK22) — int — Foreign key — NOT NULL
- following_id (PK222) — int — Foreign key — NOT NULL
- Field2
Hashtag (Untitled4)
- hashtag_id (PK) — int — Primary key — NOT NULL
- hashtag_comment (Field) — String
- Field2
Image (Untitled7)
- image_id (PK) — int — Primary key — NOT NULL
- post_id (PK2) — int — Foreign key → Post.post_id — NOT NULL
- member_id (PK22) — int — Foreign key → Post.member_id — NOT NULL
- image_count (Field) — int
- Field2
Like (Untitled2)
- like_id (PK) — int — Primary key — NOT NULL
- member_id (PK2) — int — Foreign key → Memeber.member_id — NOT NULL
- post_id (PK3) — int — Foreign key → Post.post_id — NOT NULL
- Field2
Memeber (Untitled6)
- member_id (PK) — int — Primary key — NOT NULL
- member_name (Field) — String
- password (Field2) — String
- Field3
Post (Untitled)
- post_id (PK) — int — Primary key — NOT NULL
- member_id (PK2) — int — Foreign key → Memeber.member_id — NOT NULL
- post_date (Field) — date
- post_contents (Field3) — String
- Field4
- Field2
Post_Hashtag (Untitled8)
- Post_Hashtag_id (PK) — int — Primary key — NOT NULL
- post_id (PK2) — int — Foreign key → Post.post_id — NOT NULL
- member_id (PK22) — int — Foreign key → Post.member_id — NOT NULL
- hashtag_id (PK3) — int — Foreign key → Hashtag.hashtag_id — NOT NULL
- Field