OTT(OVER-THE-TOP)

Tables (10)

bookmark (찜)

  • id (아이디) — PK — Primary key — NOT NULL
  • member_id (멤버아이디) — FK — Foreign key → member.id — NOT NULL
  • media_id (미디어 아이디) — FK — Foreign key → media.id — NOT NULL
  • created_at (생성시간)
  • last_modified_at (최종수정시간)

genre (장르)

  • id (아이디) — PK — Primary key — NOT NULL
  • name (장르명)
  • media_id (미디어 아이디) — FK — Foreign key → media.id — NOT NULL
  • created_at (생성시간)
  • last_modified_at (최종수정시간)

interest (관심장르)

  • id (아이디) — PK — Primary key — NOT NULL
  • name (관심장르명)
  • member_id (멤버아이디) — FK — Foreign key → member.id — NOT NULL
  • created_at (생성시간)
  • last_modified_at (최종수정시간)

media (미디어)

  • id (아이디) — PK — Primary key — NOT NULL
  • title (제목)
  • content (내용)
  • category (카테고리)
  • creator (감독)
  • cast (출연)
  • main_poster (메인 이미지)
  • title_poster (제목 이미지)
  • release_date (출시일)
  • age_rate (관람가)
  • recent (신작여부)
  • created_at (생성시간)
  • last_modified_at (최종수정시간)
  • Field

media_ott (미디어 오티티)

  • id (아이디) — PK — Primary key — NOT NULL
  • name (OTT이름)
  • Field (OTT 사이트)
  • media_id (미디어 아이디) — FK — Foreign key → media.id — NOT NULL
  • created_at (생성시간)
  • last_modified_at (최종수정시간)

member (멤버)

  • id (아이디) — PK — Primary key — NOT NULL
  • email (이메일)
  • password (비밀번호)
  • nickname (이름)
  • avatar_url (멤버 사진)
  • created_at (생성시간)
  • last_modified_at (최종수정시간)

member_ott (멤버 보유 OTT)

  • id (아이디) — PK — Primary key — NOT NULL
  • name (OTT이름)
  • member_id (멤버아이디) — FK — Foreign key → member.id — NOT NULL
  • created_at (생성시간)
  • last_modified_at (최종수정시간)

recommedation (추천)

  • id (아이디) — PK — Primary key — NOT NULL
  • member_id (멤버아이디) — FK — Foreign key → member.id — NOT NULL
  • media_id (미디어 아이디) — FK — Foreign key → media.id — NOT NULL
  • created_at (생성시간)
  • last_modified_at (최종수정시간)

report (오류제보)

  • id (아이디) — PK — Primary key — NOT NULL
  • member_id (멤버 아이디) — FK — Foreign key → member.id — NOT NULL
  • media_id (미디어 아이디) — FK — Foreign key → media.id — NOT NULL
  • title (제목)
  • content (내용)
  • completion (해결여부)
  • created_at (생성시간)
  • last_modified_at (최종수정시간)

review (리뷰)

  • id (아이디) — PK — Primary key — NOT NULL
  • content (내용)
  • member_id (멤버 아이디) — FK — Foreign key → member.id — NOT NULL
  • media_id (미디어 아이디) — FK — Foreign key → media.id — NOT NULL
  • created_at (생성시간)
  • last_modified_at (최종수정시간)