now

Tables (42)

account_history

  • account_history_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • wallet_id — char(36) — Foreign key — NOT NULL
  • user_id — int — Foreign key — NOT NULL
  • account_number — varchar(255) — NOT NULL
  • account_owner_name — varchar(255) — NOT NULL
  • bank_code — varchar(255) — NOT NULL

admins

  • admin_id — varchar(30) — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • password — varchar(1000) — NOT NULL
  • name — varchar(20) — NOT NULL
  • team — varchar(20) — NOT NULL
  • roles — enum('master','admin','dev') — NOT NULL
  • phone — varchar(30) — NOT NULL
  • email — varchar(500) — NOT NULL

app_push

  • app_push_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • has_seen — tinyint — NOT NULL
  • data — varchar(3000) — NOT NULL
  • user_id — int — Foreign key — NOT NULL
  • app_push_mold_id — varchar(255) — Foreign key → app_push_mold.app_push_mold_id — NOT NULL

app_push_mold

  • app_push_mold_id — varchar(255) — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • push_type — varchar(255)
  • title — varchar(100) — NOT NULL
  • body — varchar(500) — NOT NULL
  • deep_link — varchar(1000)

auction_bid_history

  • auction_bid_history_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • auction_bid_id — char(36) — Foreign key → auction_bids.auction_bid_id
  • bid_price — int — NOT NULL
  • bid_count — int — NOT NULL
  • successful_bid_count — int — NOT NULL
  • bid_history_type — enum('create','update','confirm') — NOT NULL
  • bid_status — enum('fail','in_progress','partial_success','success','cancel') — NOT NULL

auction_bids

  • auction_bid_id — char(36) — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • bid_price — int — NOT NULL
  • bid_count — int — NOT NULL
  • successful_bid_count — int — NOT NULL
  • bid_status — enum('fail','in_progress','partial_success','success','cancel') — NOT NULL
  • user_id — int — Foreign key — NOT NULL
  • auction_id — int — Foreign key → auctions.auction_id — NOT NULL

auction_feature

  • id — int — Primary key — NOT NULL
  • auction_id — int — Foreign key → auctions.auction_id — NOT NULL
  • feature_id — int — Foreign key → features.id — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)

auctions

  • auction_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • auction_start_datetime — datetime
  • auction_end_datetime — datetime
  • auction_count — int — NOT NULL
  • start_price — int — NOT NULL
  • auction_status — enum('expected','inProgress','closed') — NOT NULL
  • channel_id — varchar(255) — Foreign key → channels.channel_id — NOT NULL
  • remained_count — int — NOT NULL
  • total_sales_revenue — int — NOT NULL
  • auction_round — int — NOT NULL

banks

  • bank_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • logo — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • code — varchar(255) — NOT NULL

banner_details

  • image_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • banner_id — int — NOT NULL
  • image_url — varchar(2000) — NOT NULL

banners

  • banner_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • image_url — varchar(2000) — NOT NULL
  • banner_type — varchar(50) — NOT NULL

blacklist

  • id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • user_id — int
  • unique_key — varchar(255)
  • uid_kakao — varchar(255)
  • uid_apple — varchar(255)

buy_orders

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • order_quantity — int — NOT NULL
  • total_traded_quantity — int — NOT NULL
  • order_status — enum('open','closed','canceled') — NOT NULL
  • unit_price — int — NOT NULL
  • user_id — int — Foreign key — NOT NULL
  • channel_id — varchar(255) — Foreign key → channels.channel_id

channel_descriptions

  • id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • description — text — NOT NULL
  • channel_id — varchar(255) — Foreign key → channels.channel_id — NOT NULL

channel_images

  • channel_imageId — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • image_url — varchar(255) — NOT NULL
  • image_type — varchar(255) — NOT NULL
  • channel_id — varchar(255) — Foreign key → channels.channel_id — NOT NULL

channel_listeners

  • channel_listener_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • channel_id — varchar(255) — Foreign key → channels.channel_id — NOT NULL
  • user_id — int — Foreign key — NOT NULL

channel_monthly_ad_revenue

  • id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • profit — int — NOT NULL
  • circulating_supply — int — NOT NULL
  • copyright_fee_firstday — date — NOT NULL
  • copyright_fee_lastday — date — NOT NULL
  • channel_id — varchar(255) — Foreign key → channels.channel_id — NOT NULL
  • settlement_date — datetime
  • snapshot_date — datetime

channel_videos

  • channel_video_id — varchar(255) — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • published_at — varchar(255) — NOT NULL
  • duration — varchar(50) — NOT NULL
  • video_title — varchar(1000) — NOT NULL
  • video_thumbnail_url — varchar(2000) — NOT NULL
  • view_count — int
  • video_type — enum('normal','popular') — NOT NULL
  • channel_id — varchar(255) — Foreign key → channels.channel_id — NOT NULL

channels

  • channel_id — varchar(255) — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • publishedAt — varchar(255) — NOT NULL
  • channel_title — varchar(300) — NOT NULL
  • subscriber_count — int — NOT NULL
  • logo_image_url — varchar(2000) — NOT NULL
  • main_thumbnail_url — varchar(3000) — NOT NULL
  • description — varchar(3000)
  • view_count — int
  • hidden_subscriber_count — tinyint — NOT NULL
  • circulating_supply — int — NOT NULL
  • max_supply — int — NOT NULL
  • channel_status — enum('expected_auction','in_progress_auction','closed_auction_with_trade','in_progress_trade_with_auction','closed_trade','abolition_trade') — NOT NULL
  • partner_id — int — Foreign key → partners.partner_id

companies

  • id — int — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • account_bank_name — varchar(255) — NOT NULL
  • account_number — varchar(255) — NOT NULL
  • account_owner_name — varchar(255) — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)

delist_history

  • id — char(36) — Primary key — NOT NULL
  • channel_id — varchar(255) — Foreign key → channels.channel_id — NOT NULL
  • unitPrice — int — NOT NULL
  • createdAt — datetime(6) — NOT NULL

event_first_charge

  • id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • point — int — NOT NULL
  • user_id — int — Foreign key — NOT NULL

event_sign_up

  • id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • point — int — NOT NULL
  • user_id — int — Foreign key — NOT NULL

exchange_history

  • exchange_history_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • type — enum('deposit','withdrawal','auction','trade_sell','trade_buy','copyright_fee','event','None') — NOT NULL
  • status — enum('waiting','done','cancel','fail_certifications','fail_insufficient_balance','fail_broken_account','checking_account') — NOT NULL
  • variable_amount — int — NOT NULL
  • fee — int — NOT NULL
  • balance — int
  • description — varchar(255) — NOT NULL
  • description_additional — varchar(255) — NOT NULL
  • wallet_id — char(36) — Foreign key
  • pending_exchange_id — int — Foreign key → pending_exchanges.pending_exchange_id
  • transaction_type_code — char(1) — Foreign key
  • account_history_id — int

faqs

  • faq_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • type — enum('cash','account','auction','trade','other')
  • title — varchar(300) — NOT NULL
  • description — varchar(2000)

fcm_token

  • fcm_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • fcm_token — varchar(500) — NOT NULL
  • user_id — int — NOT NULL

features

  • id — int — Primary key — NOT NULL
  • kind — varchar(255) — NOT NULL
  • description — text — NOT NULL
  • createdAt — datetime(6) — NOT NULL

fee_history

  • record_id — int — Primary key — NOT NULL
  • fee — decimal(10,6) — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • transaction_type_code — char(4) — Foreign key
  • isPercent — char(1) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL

holder_history_entity

  • id — int — Primary key — NOT NULL
  • type — enum('plus','minus') — NOT NULL
  • channel_id — varchar(255) — Foreign key → channels.channel_id — NOT NULL
  • user_id — int — Foreign key — NOT NULL
  • quantity — int — NOT NULL
  • cost — int — NOT NULL
  • holding_quantity — int — NOT NULL
  • accumulated_cost — int — NOT NULL
  • accumulated_quantity — int — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)

holders

  • holder_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • user_id — int — Foreign key
  • holding_quantity — int — NOT NULL
  • channel_id — varchar(255) — Foreign key → channels.channel_id

loggings

  • logging_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • message — varchar(255) — NOT NULL

notices

  • notice_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • type — enum('main','advertisement') — NOT NULL
  • title — varchar(300) — NOT NULL
  • description — varchar(2000)

notification_settings

  • notification_setting_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • is_use_app_push — tinyint — NOT NULL
  • is_use_auction_notification — tinyint — NOT NULL
  • is_use_trade_notification — tinyint — NOT NULL
  • is_use_event_notification — tinyint — NOT NULL
  • user_id — int — Foreign key — NOT NULL

partners

  • partner_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • partner_status — enum('active','delete','block') — NOT NULL
  • name — varchar(100) — NOT NULL
  • phone — varchar(30) — NOT NULL
  • email — varchar(500) — NOT NULL
  • resident_number_front — varchar(255) — NOT NULL
  • resident_number_back — varchar(255) — NOT NULL
  • gender — enum('male','female') — NOT NULL
  • age — int — NOT NULL
  • channel_id — varchar(255) — Foreign key → channels.channel_id — NOT NULL

pending_accounts

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key — NOT NULL
  • account_number — varchar(255) — NOT NULL
  • status — enum('pending','approved','disapproved') — NOT NULL
  • bank_code — varchar(255) — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)

pending_exchanges

  • pending_exchange_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • description — varchar(255)
  • staging_amount — int — NOT NULL
  • fee — int
  • wallet_id — char(36) — Foreign key — NOT NULL
  • transaction_type_code — char(1) — Foreign key
  • status — enum('waiting','done','cancel','fail_certifications','fail_insufficient_balance','fail_broken_account','checking_account') — NOT NULL

promotions

  • promotion_code — varchar(255) — Primary key — NOT NULL
  • title — varchar(255) — NOT NULL
  • description — varchar(255) — NOT NULL
  • aboutOption — varchar(255) — NOT NULL
  • benefitsType — varchar(255) — NOT NULL
  • cashProvisionAmount — int — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)

rolling_users

  • id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • user_id — int — NOT NULL
  • nickname — varchar(20) — NOT NULL
  • profit — int — NOT NULL
  • copyright_fee_firstday — date — NOT NULL

rules

  • rule_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • rule_title — varchar(255) — NOT NULL
  • rule_type — enum('sell','buy','bid','auction_participation','auction_rebid','trade','charging','withdraw') — NOT NULL

rules_items

  • rules_item_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • rule — varchar(255) — NOT NULL
  • rule_type — enum('normal','specific','part_normal','part_specific') — NOT NULL
  • rule_id — int — Foreign key → rules.rule_id — NOT NULL

schedules

  • schedules_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • snapshots_day — varchar(255) — NOT NULL
  • snapshots_time — varchar(255) — NOT NULL
  • settlement_day — varchar(255) — NOT NULL
  • settlement_time — varchar(255) — NOT NULL
  • expected_profit_day — varchar(255) — NOT NULL

sell_orders

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • order_quantity — int — NOT NULL
  • total_traded_quantity — int — NOT NULL
  • unit_price — int — NOT NULL
  • order_status — enum('open','closed','canceled') — NOT NULL
  • user_id — int — NOT NULL
  • channel_id — varchar(255) — Foreign key → channels.channel_id — NOT NULL