owncast

Tables (11)

BookMark (Untitled3)

  • id — bigint — Primary key — NOT NULL
  • 북미크 (content) — string
  • 북마크번역 (contentKorea) — string
  • id (scrpt_id) — Script — Foreign key → Script.id — NOT NULL
  • id (member_id) — Member — Foreign key → Member.id — NOT NULL

Category (Untitled9)

  • id — bigint — Primary key — NOT NULL
  • Field (name) — string
  • id (script_id) — Script — Foreign key → Script.id — NOT NULL

DetailPrefer (Untitled4)

  • id — bigint — Primary key — NOT NULL
  • id (mainPrefer_id) — MainPrefer — Foreign key → MainPrefer.id — NOT NULL
  • 세부분야 (prefer) — string

MainPrefer (Untitled7)

  • id — bigint — Primary key — NOT NULL
  • id (member_id) — Member — Foreign key → Member.id — NOT NULL
  • 주분야 (prefer) — enum

Member (Untitled)

  • id — bigint — Primary key — NOT NULL
  • 이름 (name) — varchar
  • 닉네임 (nickname) — varchar
  • 비밀번호 (pasword) — varchar
  • 이메일 (email) — varchar
  • 언어 (language) — enum

MemberLikes (Untitled11)

  • id — bigint — Primary key — NOT NULL
  • id (Member_id) — Member — Foreign key → Member.id — NOT NULL
  • id (script_id) — Script — Foreign key → Script.id — NOT NULL

MemberSaved (Untitled10)

  • id — bigint — Primary key — NOT NULL
  • id (script_id) — Script — Foreign key → Script.id — NOT NULL
  • id (member_id) — Member — Foreign key → Member.id — NOT NULL

PlayList (Untitled6)

  • id — bigint — Primary key — NOT NULL
  • id (member_id) — Member — Foreign key → Member.id — NOT NULL
  • id (category_id) — Category — Foreign key → Category.id — NOT NULL
  • id (memberSaved_id) — MemberrSaved — Foreign key → MemberSaved.id — NOT NULL
  • Key (memberLikes_id) — MemberLikes — Foreign key → MemberLikes.id — NOT NULL

PlayList_Image (Untitled8)

  • Key — Primary key — NOT NULL
  • 이미지 (img) — text
  • id (playList_id) — PlayList — Foreign key → PlayList.id — NOT NULL

Script (Untitled5)

  • id — bigint — Primary key — NOT NULL
  • 키워드 (keyword) — string
  • 오디오스타일 (audio) — enum
  • 목소리스타일 (tts) — enum
  • 분량 (amount) — integer
  • 스크립트 (content) — string
  • 스크립트번역 (contentKorea) — string
  • 제목 (title) — varchar
  • 카테고리 (category) — string
  • id (member_id) — Member — Foreign key → Member.id — NOT NULL

Script_Image (Untitled2)

  • Key — Primary key — NOT NULL
  • 이미지 (img) — text
  • id (script_id) — Script — Foreign key → Script.id — NOT NULL