my settlement

Tables (8)

Contract (계약서)

  • id (Key) — Long — Primary key — NOT NULL
  • distributorId (유통사) — Long — Foreign key → Distributor.id — NOT NULL
  • ostId (ost) — Long — Foreign key → Ost.Key — NOT NULL
  • producerPercent (제작사 퍼센트) — Double
  • singerPercent (가창자 퍼센트) — Double
  • startDate (시작일) — LocalDateTime
  • endDate (종료일) — LocalDateTime
  • updatedAt (업데이트 날짜) — LocalDateTime
  • createdAt (생성 날짜) — LocalDateTime

Distributor (유통사)

  • id (Key) — Long — Primary key — NOT NULL
  • name (유통사명) — String
  • percent (유통사 퍼센트) — Double

Drama (드라마)

  • id (Key) — Long — Primary key — NOT NULL
  • title (드라마명) — String

Ost

  • Key — Long — Primary key — NOT NULL
  • dramaId (드라마) — Long — Foreign key → Drama.id — NOT NULL
  • producerId (제작사) — Long — Foreign key → Producer.id — NOT NULL
  • singerId (가창자) — Long — Foreign key → Singer.id — NOT NULL
  • title (제목) — String

Producer (제작사)

  • id (Key) — Long — Primary key — NOT NULL
  • name (제작사명) — String

Settlement (정산)

  • id (Key) — Long — Primary key — NOT NULL
  • contractId (계약서) — Long — Foreign key → Contract.id — NOT NULL
  • type (정산대상 타입) — Long
  • memberId (정산 대상 id) — Long
  • settleDate (정산일) — LocalDateTime
  • fee (정산금) — Double
  • updateDate (업데이트 시간) — LocalDateTime

Singer (가창자)

  • id (Key) — Long — Primary key — NOT NULL
  • name (가수 이름) — String

revenue (수익 계산서)

  • id (Key) — Long — Primary key — NOT NULL
  • contractId (계약서) — Long — Foreign key → Contract.id — NOT NULL
  • date (날짜) — LocalDateTime
  • fee (수익) — Double