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