Echo SNS
Tables (6)
COMMENT
- id — VARCHAR(255) — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- comment — VARCHAR(255)
- likes — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME — NOT NULL
- post_id — VARCHAR(255) — Foreign key → POST.id — NOT NULL
FOLLOW
- id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- following_id — BIGINT — Foreign key → USER.id — NOT NULL
- follower_id — BIGINT — Foreign key → USER.id — NOT NULL
MESSAGE
- id — VARCHAR(255) — Primary key — NOT NULL
- content — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- sender_id — BIGINT — Foreign key → USER.id — NOT NULL
- receiver_id — BIGINT — Foreign key → USER.id — NOT NULL
POST
- id — VARCHAR(255) — Primary key — NOT NULL
- content — VARCHAR — NOT NULL
- likes — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- comment_count — BIGINT — NOT NULL
- nickname — VARCHAR — NOT NULL
- user_id — BIGINT — Foreign key → USER.id — NOT NULL
POST_IMAGE
- id — VARCHAR(255) — Primary key — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
- post_id — BIGINT — Foreign key → POST.id — NOT NULL
USER
- id — BIGINT — Primary key — NOT NULL
- nickname — VARCHAR — NOT NULL
- password — VARCHAR — NOT NULL
- username — VARCHAR — NOT NULL
- phone — VARCHAR — NOT NULL
- bio — VARCAHR
- profile_img — VARCHAR
- background_img — VARCHAR
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL