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