Clone
Tables (7)
comment
- id — BIGINT — Primary key — NOT NULL
- content — VARCHAR(255) — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- post_id — BIGINT — Foreign key → post.id — NOT NULL
commentLike
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- comment_id — BIGINT — Foreign key → comment.id — NOT NULL
follow
- id — BIGINT — Primary key — NOT NULL
- from_user_id — BIGINT — Foreign key → user.id — NOT NULL
- to_user_id — BIGINT — Foreign key → user.id — NOT NULL
post
- id — BIGINT — Primary key — NOT NULL
- imageSource — VARCHAR(255) — NOT NULL
- description — BLOB
- user_id — BIGINT — Foreign key → user.id — NOT NULL
postLike
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- post_id — BIGINT — Foreign key → post.id — NOT NULL
tag
- id — BIGINT — Primary key — NOT NULL
- tagname — VARCHAR(50) — NOT NULL
- post_id — BIGINT — Foreign key → post.id — NOT NULL
user
- id — BIGINT — Primary key — NOT NULL
- username — VARCHAR(20) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- email — VARCHAR(50) — NOT NULL
- description — VARCHAR(255)
- profileImage — VARCHAR(255)
- createAt — DATETIME — NOT NULL
- modifiedDate — DATETIME — NOT NULL