Profit
Tables (8)
board_post
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- view_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
comment
- id — BIGINT — Primary key — NOT NULL
- board_post_id — BIGINT — Foreign key → board_post.id — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
cost_detail
- id — BIGINT — Primary key — NOT NULL
- project_id — BIGINT — Foreign key → project.id — NOT NULL
- category — VARCHAR(50) — NOT NULL — API_USAGE, SERVER, TOOL_SUBSCRIPTION, MATERIAL, MARKETING, OUTSOURCING, OTHER
- cost_name — VARCHAR(255) — NOT NULL
- cost_type — VARCHAR(20) — NOT NULL — FIXED, VARIABLE
- amount — DECIMAL(19, 4) — NOT NULL
- memo — VARCHAR(500)
- created_at — DATETIME — NOT NULL
member
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
persona
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- biz_type — VARCHAR(50) — NOT NULL — TIME_INVESTOR, COST_SPENDER
- monthly_revenue — DECIMAL(19, 4)
- main_platform — VARCHAR(100)
- work_hours_per_week — DECIMAL(5, 1)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
project
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- fixed_cost — DECIMAL(19,4) — NOT NULL
- variable_cost — DECIMAL(19,4) — NOT NULL
- price — DECIMAL(19,4) — NOT NULL
- creator_category — VARCHAR(50)
- script_inputs — JSON
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
report
- id — BIGINT — Primary key — NOT NULL
- project_id — BIGINT — Foreign key → project.id — NOT NULL
- year_month — VARCHAR(7) — NOT NULL — yyyy-MM
- content — LONGTEXT — NOT NULL
- tokens_used — INT
- created_at — DATETIME — NOT NULL
time_log
- id — BIGINT — Primary key — NOT NULL
- project_id — BIGINT — Foreign key → project.id — NOT NULL
- task_name — VARCHAR(255) — NOT NULL
- hours_spent — DECIMAL(5,1) — NOT NULL
- log_date — DATE — NOT NULL
- memo — VARCHAR(500)
- created_at — DATETIME — NOT NULL