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