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