3ㄷ53463

Tables (14)

comments

  • comment_id — TINYINT
  • post_id — TINYINT — NOT NULL
  • like — INT

contents

  • content_id — TINYINT
  • creator_id — TINYINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • plan_id — TINYINT
  • category — ENUM('EXERCISE','SPORTS','COOKING','STUDY','ART','MUSIC','PHOTO_VIDEO','IT','GAME','ETC')
  • created_at — DATETIME
  • updated_at — DATETIME

creator

  • creator_id — TINYINT
  • display_name — VARCHAR(100) — NOT NULL
  • profile — TEXT
  • follow_count — INT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • is_deleted — BOOLEAN

creator_follow

  • follow_id — TINYINT
  • user_id — TINYINT — NOT NULL
  • creator_id — TINYINT — NOT NULL
  • created_at — DATETIME

creator_settlements

  • creator_settlement_id — TINYINT
  • run_id — TINYINT — NOT NULL
  • creator_id — TINYINT — NOT NULL
  • gross_amount — INT
  • platform_fee — INT
  • payout_amount — INT
  • settlement_status — ENUM('CALCULATING','PAID') — NOT NULL
  • created_at — DATETIME

orders

  • order_id — VARCHAR(100)
  • user_id — TINYINT — NOT NULL
  • order_status — ENUM('READY','PAID','CANCELED','EXPIRED') — NOT NULL
  • created_at — DATETIME
  • expired_at — DATETIME

payments

  • payment_id — TINYINT
  • user_id — TINYINT — NOT NULL
  • order_id — VARCHAR(100) — NOT NULL
  • amount — INT — NOT NULL
  • credit_method — ENUM('CARD','VIRTUAL_BANK')
  • credit_status — ENUM('READY','PAID','CANCELED','REFUNDED')
  • paid_at — DATETIME
  • created_at — DATETIME

posts

  • post_id — TINYINT
  • creator_id — TINYINT — NOT NULL
  • content_id — TINYINT — NOT NULL
  • body — TEXT — NOT NULL
  • url — TEXT — NOT NULL

roles

  • role_id — TINYINT
  • role — ENUM('USER','CREATOR','ADMIN') — NOT NULL

settlement_runs

  • run_id — TINYINT
  • period_start — DATE
  • period_end — DATE
  • run_status — ENUM('READY','RUN','DONE') — NOT NULL
  • executed_at — DATETIME

subscribes

  • subscribe_id — TINYINT
  • user_id — TINYINT — NOT NULL
  • plan_id — TINYINT — NOT NULL
  • subscribe_status — ENUM('INACTIVE','ACTIVE','CANCELED','EXPIRED') — NOT NULL
  • start_at — DATETIME
  • end_at — DATETIME
  • created_at — DATETIME

subscription_plans

  • plan_id — TINYINT
  • creator_id — TINYINT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • price — INT — NOT NULL
  • is_active — BOOLEAN
  • created_at — DATETIME

user_role

  • user_id — TINYINT — Primary key — NOT NULL
  • role_id — TINYINT — Primary key — NOT NULL

users

  • user_id — TINYINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • updated_at — DATETIME
  • created_at — DATETIME