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