Leto 정산

테이블 (11)

Calculation

  • id — bigint — 기본 키 — NOT NULL
  • work_id — bigint — 외래 키 → Work.id — NOT NULL
  • platform_code — varchar(100) — 외래 키 → Common_code.code — NOT NULL
  • calculation_date — datetime
  • exclusive_right_code (exclusive right_code) — varchar(100) — 외래 키 → Common_code.code — NOT NULL
  • exclusive_right_period — varchar(100)
  • net_sales — bigint
  • share_of_writer — bigint
  • company_net_income — bigint
  • pre_pre_paid — bigint
  • pre_paid_cover — bigint
  • deleted — boolean — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • pre_platform_pre_paid — bigint
  • platform_pre_paid_cover — bigint
  • pre_member_platform_pre_paid — bigint
  • member_platform_pre_paid_cover — bigint

Common_code

  • code — varchar(100) — 기본 키 — NOT NULL
  • parent_code — varchar(100) — 외래 키 → Common_code.code
  • code_name — varchar(100)
  • valid — boolean — NOT NULL
  • remark — text
  • deleted — boolean — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

Member

  • id — varchar(100) — 기본 키 — NOT NULL
  • password — varchar(200)
  • role — varchar(10) — NOT NULL — enum(ADMIN, USER)
  • name — varchar(50)
  • bank_name — varchar(50)
  • bank_account — varchar(50)
  • address — varchar(100)
  • phone_number — varchar(50)
  • deleted — boolean — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • social_security_number — varchar(60)
  • income_tax_rate — decimal(5,2)

Member_platform_pre_paid

  • id — bigint — 기본 키 — NOT NULL
  • member_id — varchar(100) — 외래 키 → Member.id — NOT NULL
  • member_platform_pre_paid_platform — varchar(100)
  • member_platform_pre_paid — bigint
  • member_platform_pre_paid_remaining — bigint
  • revenue_share_code — varchar(100)
  • deleted — boolean
  • created_at — datetime
  • updated_at — datetime

Notice

  • id — bigint — 기본 키 — NOT NULL
  • title — varchar(200)
  • member_id — varchar(100) — 외래 키 → Member.id — NOT NULL
  • content — text
  • deleted — boolean — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

Team

  • id — varchar(100) — 기본 키 — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • deleted — boolean

Team_members

  • team_id — varchar(100) — 외래 키 → Team.id — NOT NULL
  • member_id — varchar(100) — 외래 키 → Member.id — NOT NULL
  • deleted (Field) — boolean
  • created_at — datetime
  • updated_at — datetime

Teamed_work

  • id — bigint — 기본 키 — NOT NULL
  • work_id — bigint — 외래 키 → Work.id — NOT NULL
  • member_id — varchar(100) — 외래 키 → Member.id — NOT NULL
  • revenue_share_code (revenue_share) — DECIMAL(3, 1)
  • pre_paid — bigint
  • pre_paid_remaining — bigint
  • deleted — boolean
  • created_at — datetime
  • updated_at — datetime

Work

  • id — bigint — 기본 키 — NOT NULL
  • member_id — varchar(100) — 외래 키 → Member.id — NOT NULL
  • name — varchar(200)
  • writer_nickname — varchar(100)
  • publication_date — date
  • label_code — varchar(100) — 외래 키 → Common_code.code — NOT NULL
  • revenue_share_code — varchar(100) — 외래 키 → Common_code.code — NOT NULL
  • pre_paid — bigint
  • pre_paid_remaining — bigint
  • down_payment — bigint
  • deleted — boolean — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • exclusive_platform_code1 — varchar(100)
  • exclusive_platform_code2 — varchar(100)
  • exclusive_platform_code3 — varchar(100)
  • platform_pre_paid — bigint
  • platform_pre_paid_remaining — bigint
  • platform_pre_paid_platform — varchar(100)

payment_detail

  • id — bigint — 기본 키 — NOT NULL
  • member_id — varchar(100) — 외래 키 → Member.id — NOT NULL
  • payment_date — datetime
  • total_share_of_writer — bigint
  • income_tax_rate — decimal(5,2)
  • resident_tax — bigint
  • amount — bigint
  • bank_name — varchar(50)
  • bank_account — varchar(50)
  • remark — text
  • deleted — boolean — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • writer_nickname — varchar(100)

platform_pre_paid_pre_paid_cover_history

  • id — bigint — 기본 키 — NOT NULL
  • work_id — bigint — 외래 키 → Work.id — NOT NULL
  • team_member_id — varchar(100) — 외래 키 → Member.id — NOT NULL
  • calculation_id — bigint
  • pre_pre_paid — bigint
  • pre_paid_cover — bigint
  • deleted — boolean
  • created_at — datetime
  • updated_at — datetime