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