erd
Tables (10)
Comment (Untitled4)
- comment_id (Key) — int — Primary key — NOT NULL
- freePost_id (Key2) — int — Foreign key → freePost.freePost_id — NOT NULL
- user_id (Key3) — int — Foreign key → User.user_id — NOT NULL
- content (Field) — varchar(100)
CommentLIke (Untitled9)
- Key — int — Primary key — NOT NULL
- user_id (Key2) — int — Foreign key → User.user_id — NOT NULL
- comment_id (Key3) — int — Foreign key → Comment.comment_id — NOT NULL
Community (CopyOfUntitled)
- community_id (Key) — int — Primary key — NOT NULL
- user_id (Key2) — int — Foreign key → User.user_id — NOT NULL
- title (Field) — varchar(30)
- body (Field2) — text
- date (Field3) — date
Follow (Untitled7)
- follow_id (Key) — int — Primary key — NOT NULL
- following_id (Key2) — int — Foreign key → User.user_id — NOT NULL
- follower_id (Key3) — int — Foreign key → User.user_id — NOT NULL
Hashtags (Untitled5)
- hashtag_id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar(30)
Image (Untitled3)
- image_id (Key) — int — Primary key — NOT NULL
- freePost_id (Key2) — int — Foreign key → freePost.freePost_id — NOT NULL
- community_id (Key4) — int — Foreign key → Community.community_id — NOT NULL
- src (Field) — varchar(200)
PostLIke (Untitled8)
- like_id (Key) — int — Primary key — NOT NULL
- freePost_id (Key2) — int — Foreign key → freePost.freePost_id — NOT NULL
- user_id (Key3) — int — Foreign key → User.user_id — NOT NULL
Posthashtag (Untitled6)
- posthashtag_id (Key3) — int — Primary key — NOT NULL
- freePost_id (Key) — int — Foreign key → freePost.freePost_id — NOT NULL
- hashtag_id (Key2) — int — Foreign key → Hashtags.hashtag_id — NOT NULL
User (Untitled2)
- user_id (Key) — int — Primary key — NOT NULL
- email (Field) — varchar(30)
- id (Field2) — varchar(30)
- password (Field3) — varchar(30)
- nickname (Field5) — varchar(30)
- question (Field6) — varchar(100)
freePost (Untitled)
- freePost_id (Key) — int — Primary key — NOT NULL
- user_id (Key2) — int — Foreign key → User.user_id — NOT NULL
- title (Field) — varchar(30)
- body (Field2) — text
- date (Field3) — date
- checkbox (Field5) — varchar(30)