sns 2
Tables (8)
Comment (Untitled3)
- comment_id (PK) — Primary key — NOT NULL
- commnet_content (Field)
- member_id (FK) — Foreign key → Member.member_id — NOT NULL
- post_id (F.K) — Foreign key → Post.post_id — NOT NULL
Hashtag (Untitled5)
- hashtag_id (Key) — Primary key — NOT NULL
- hasgtag_title (Field)
Like (Untitled4)
- like_id (PK) — Primary key — NOT NULL
- post_id (FK) — Foreign key → Post.post_id — NOT NULL
- member_id (F.K) — Foreign key → Member.member_id — NOT NULL
Member (Untitled)
- member_id (PK) — Primary key — NOT NULL
- nickname (Field)
- email (Field2)
- phone (Field3)
Member_member (Untitled8)
- id (Key) — Primary key — NOT NULL
- src_member_id (FK) — Foreign key → Member.member_id — NOT NULL
- dst_member2_id (F.K) — Foreign key → Member.member_id — NOT NULL
Photo (Untitled7)
- photo_id (PK) — Primary key — NOT NULL
- url (Field)
- post_id (FK) — Foreign key → Post.post_id — NOT NULL
Post (Untitled2)
- post_id (PK) — Primary key — NOT NULL
- post_comment (Field)
- member_id (FK) — Foreign key → Member.member_id — NOT NULL
Post_hashtag (Untitled6)
- post_hashtag_id (PK) — Primary key — NOT NULL
- hashtag_id (FK) — Foreign key → Hashtag.hashtag_id — NOT NULL
- post_id (F.K) — Foreign key → Post.post_id — NOT NULL