ㅇㄴㅁ
Tables (13)
board
- id — bigint — Primary key — NOT NULL
- title — varchar — NOT NULL
- content — varchar
- category — varchar
- view_count — int
- like_count — int
- created_at — datetime
- updated_at — datetime
- user_id — bigint — NOT NULL
board_comment
- id — bigint — Primary key — NOT NULL
- content — text
- created_at — datetime
- user_id — bigint — NOT NULL
- board_id — bigint
board_like
- id — bigint — Primary key — NOT NULL
- board_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
class
- id — bigint — Primary key — NOT NULL
- title — varchar
- description — varchar
- date — datetime
- location — varchar
- capacity — int
- price — int
- created_at — datetime
- host_id — bigint — NOT NULL
class_entrollment
- id — bigint — Primary key — NOT NULL
- status — enum
- created_at — datetime
- payment_type — enum
- class_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
- order_id — bigint — NOT NULL
follow
- id — bigint — Primary key — NOT NULL
- follower_id — bigint — NOT NULL
- following_id — bigint — NOT NULL
orders
- id — bigint — Primary key — NOT NULL
- price — int
- merchant_uid — varchar
- order_type — enum
- order_status — enum
- created_at — datetime
- user_id — bigint — NOT NULL
payments
- id — bigint — Primary key — NOT NULL
- payment_id — varchar
- pay_method — varchar
- price — int
- payments_status — enum
- created_at — datetime
- cancelled_at — datetime
- cancel_reason — varchar
- approved_at — datetime
- order_id — bigint — NOT NULL
reply
- id — bigint — Primary key — NOT NULL
- content — varchar
- adopted — boolean
- board_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
reply_comment
- id — bigint — Primary key — NOT NULL
- content — text
- created_at — datetime
- reply_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
report
- id — bigint — Primary key — NOT NULL
- content — varchar
- isDone — boolean
- created_at — datetime
- board_id — bigint — NOT NULL
subscriptions
- Key — VARCHAR(255) — Primary key — NOT NULL
- plan_type — enum
- billing_key — varchar
- sub_status — enum
- remaining_pass_count — int
- current_period_start — datetime
- current_period_end — datetime
- next_billing_date — datetime
- user_id — bigint — NOT NULL
user
- id — bigint — Primary key — NOT NULL
- email — varchar
- password — varchar
- nickname — varchar
- name — varchar
- status — enum
- created_at — datetime
- role — enum
- provider — enum
- provider_id — varchar