instagram clone
Tables (4)
Article
- Key (article_id) — int — Primary key — NOT NULL
- Key (user_id) — Int — Foreign key → User.Key — NOT NULL
- Field (content) — varchar
- Field (Image)
- Field (updated_at) — date
- Field (created_at) — date
Comment (comment)
- Key (comment_id) — int — Primary key — NOT NULL
- Key (article_id) — int — Foreign key → Article.Key — NOT NULL
- Key (user_id) — Int — Foreign key → User.Key — NOT NULL
- Field (content) — varchar
- Field
Like (Untitled)
- Key (article_id) — int — Foreign key → Article.Key — NOT NULL
- Key (user_id) — Int — Foreign key → User.Key — NOT NULL
User
- Key (user_id) — Int — Primary key — NOT NULL
- Key (username) — varchar — Primary key — NOT NULL
- Field (email) — email
- Field — int
- Field (이름) — varchar
- Field (성) — varchar
- Field (비밀번호) — password
- Key (user_id2) — Int — Foreign key → User.Key — NOT NULL