SNS
Tables (6)
comment
- id — INT — Primary key — NOT NULL
- postId — INT — Foreign key → post.id — NOT NULL
- userId — INT — Foreign key → user.id — NOT NULL
- desc — VARCHAR(200) — NOT NULL
- createdAt — DATETIME
like
- id — INT — Primary key — NOT NULL
- likeUerId (userId) — INT — Foreign key → user.id — NOT NULL
- likePostId (postId) — INT — Foreign key → post.id — NOT NULL
post
- id — INT — Primary key — NOT NULL
- userId — INT — Foreign key → user.id — NOT NULL
- desc — VARCHAR(200)
- img — VARCHAR(200)
- createdAt — DATETIME — NOT NULL
relationship
- id — INT — Primary key — NOT NULL
- followerUserId — INT — Foreign key → user.id — NOT NULL
- followedUserId — INT — Foreign key → user.id — NOT NULL
stories
- id — INT — Primary key — NOT NULL
- img — VARCHAR(200) — NOT NULL
- storyUserId (id2) — INT — Foreign key → user.id — NOT NULL
user
- id — INT — Primary key — NOT NULL
- username — VARCHAR(45) — NOT NULL
- email — VARCHAR(45) — NOT NULL
- password — VARCHAR(200) — NOT NULL
- name — VARCHAR(45) — NOT NULL
- coverPic — VARCHAR(100)
- profilePic — VARCHAR(100)
- city — VARCHAR(45)
- website — VARCHAR(45)