snsV5
Tables (7)
File (Untitled3)
- file_id (Key) — Primary key — NOT NULL
- post_id (Key2) — Foreign key → Post.post_id — NOT NULL
- file_name (Field)
Hashtag (Untitled6)
- hashtag_id (Key) — Primary key — NOT NULL
- hashtag_name (Field)
Like (Untitled5)
- like_id (Key) — Primary key — NOT NULL
- member_idx (Key2) — Foreign key → Member.member_idx — NOT NULL
- post_id (Key3) — Foreign key → Post.post_id — NOT NULL
Member (Untitled)
- member_idx (Key) — Primary key — NOT NULL
- follower_idx (Key2)
- following_idx (Key3)
- member_id (Field)
- member_password (Field2)
- member_phone (Field3)
Post (Untitled2)
- post_id (Key) — Primary key — NOT NULL
- member_idx (Key2) — Foreign key → Member.member_idx — NOT NULL
- post_title (Field)
- post_content (Field2)
Post-Hashtag (Untitled7)
- post-hashtag_id (Key) — Primary key — NOT NULL
- post_id (Key2) — Foreign key → Post.post_id — NOT NULL
- hashtag_id (Key3) — Foreign key → Hashtag.hashtag_id — NOT NULL
Reply (Untitled4)
- reply_id (Key) — Primary key — NOT NULL
- post_id (Key2) — Foreign key → Post.post_id — NOT NULL
- member_idx (Key3) — Foreign key → Member.member_idx — NOT NULL
- reply_comment (Field)