ssafit

Tables (5)

Follow

  • relation_id — Primary key — NOT NULL
  • follower_id — BIGINT — Foreign key → Member.회원ID — NOT NULL
  • followee_id — BIGINT — Foreign key → Member.회원ID — NOT NULL

Like

  • like_id — Primary key — NOT NULL
  • video_id — BIGINT — Foreign key → Video.video_id — NOT NULL
  • member_id — BIGINT — Foreign key → Member.회원ID — NOT NULL
  • liked_at — TIMESTAMP

Member

  • 회원ID (member_id) — BIGINT — Primary key — NOT NULL
  • ID — VARCHAR(30) — NOT NULL
  • password — CHAR(64) — NOT NULL
  • nickname — VARCHAR(30) — NOT NULL
  • email — VARCHAR(30) — NOT NULL
  • signup_date — TIMESTAMP — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • deleted_at — TIMESTAMP

Review

  • review_id — BIGINT — Primary key — NOT NULL
  • content — VARCHAR(500)
  • created_at — TIMESTAMP
  • video_id — BIGINT — Foreign key → Video.video_id — NOT NULL
  • member_id — BIGINT — Foreign key → Member.회원ID — NOT NULL

Video

  • video_id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(50)
  • content — VARCHAR(500)
  • created_at — TIMESTAMP
  • video_address — VARCHAR(200) — NOT NULL
  • like — INT
  • member_id — BIGINT — Foreign key → Member.회원ID — NOT NULL
  • category — VARCHAR(50)