ㅇㄴㅁ

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