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