OwnCast
Tables (11)
BookMark_Script (Untitled5)
- Key — Primary key — NOT NULL
- memberId (Key2) — Member — Foreign key → Member.id — NOT NULL
- sentenceId (Key3) — Sentence — Foreign key → Sentence.id — NOT NULL
Language (CopyOfCopyOfUntitled2)
- Key — Long — Primary key — NOT NULL
- name (Field) — String
- image (Field2) — String
Member (CopyOfUntitled2)
- id (Key) — Long — Primary key — NOT NULL
- username (Field) — String
- password (Field2) — String
- email (Field3) — String
- status (Field4) — Integer
- role (Field5) — List<role>
- refreshToken (Field6) — String
- tokenExpiration (Field7) — Date
- socialProvider (Field8) — enum
- socialId (Field9) — Long
- emailVerified (Field10) — boolean
- language (Key2) — Language — Foreign key → Language.Key — NOT NULL
- subPreferCategory (Key3) — SubPreferCategory — Foreign key → SubPreferCategory.id — NOT NULL
MemberLikes (CopyOfUntitled32)
- Key — Primary key — NOT NULL
- memberId (Key2) — Member — Foreign key → Member.id — NOT NULL
- scriptId (Key3) — Script — Foreign key → Script.id — NOT NULL
MemberSaved (Untitled3)
- Key — Primary key — NOT NULL
- memberId (Key2) — Member — Foreign key → Member.id — NOT NULL
- scriptId (Key3) — Script — Foreign key → Script.id — NOT NULL
PreferCategory (Untitled)
- id (Key) — Long — Primary key — NOT NULL
- name (Field) — String
- image (Field2) — String
Script (CopyOfUntitled)
- id (Key) — Long — Primary key — NOT NULL
- title (Field) — String
- image (Field2) — String
- view (Field3) — Long
- private (Field4) — boolean
- likes (Field5) — Integer
- memberId (Key2) — Member — Foreign key → Member.id — NOT NULL
- categoryId (Key3) — SubPreferCategory — Foreign key → SubPreferCategory.id — NOT NULL
Script_Track (CopyOfUntitled4)
- id (Key) — Long — Primary key — NOT NULL
- ScriptId (Key2) — Script — Foreign key → Script.id — NOT NULL
- TrackId (Key3) — Track — Foreign key → Track.id — NOT NULL
Sentence (Untitled2)
- id (Key) — Long — Primary key — NOT NULL
- conetent (Field) — String
- ScriptId (Key2) — Script — Foreign key → Script.id — NOT NULL
SubPreferCategory (CopyOfUntitled3)
- id (Key) — Long — Primary key — NOT NULL
- name (Field) — String
- image (Field2) — String
- parentCategoryId (Key2) — Long — Foreign key → PreferCategory.id — NOT NULL
Track (Untitled4)
- id (Key) — Long — Primary key — NOT NULL
- title (Field) — String
- image (Field2) — String
- memberId (Key2) — Member — Foreign key → Member.id — NOT NULL