old

Tables (33)

app_push

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

app_push_channel

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

app_push_mold

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

auction_history

  • auction_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 → wallets.wallet_id — NOT NULL
  • auction_id — char(36) — Foreign key → auctions.auction_id — NOT NULL
  • auction_history_status — enum('cancel','again_bid','fail_bid','expect_success_part_bid','expect_success_bid','success_part_bid','success_bid') — NOT NULL

auction_rule_list

  • auction_rule_list_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • rule — varchar(255) — NOT NULL
  • auction_rule_id — int — Foreign key → auction_rules.auction_rule_id — NOT NULL

auction_rules

  • auction_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

auctions

  • auction_id — char(36) — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • bid_cash — int — NOT NULL
  • bid_count — int — NOT NULL
  • auction_status — enum('fail_bid','expect_success_part_bid','expect_success_bid','success_part_bid','success_bid','cancel') — NOT NULL
  • user_id — int — Foreign key → users.user_id
  • channel_auction_id — int — Foreign key → channel_auction.channel_auction_id

bank

  • 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 — enum('002','003','004','007','008','011','012','020','023','027','031','032','034','035','037','039','045','048','050','064','071','081','088','089','090','092') — 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

buy_trade_history

  • trade_history_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • trade_type — enum('sell','sell_cancel','buy','buy_cancel') — NOT NULL
  • traded_quantity — int — NOT NULL
  • traded_price — int — NOT NULL
  • transaction_id — char(36) — Foreign key → buy_transactions.buy_transaction_id — NOT NULL
  • channel_id — varchar(255) — Foreign key → channels.channel_id — NOT NULL

buy_transactions

  • buy_transaction_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
  • traded_quantity — int — NOT NULL
  • transaction_status — enum('ongoing','closed','cancel') — NOT NULL
  • order_price — int — NOT NULL
  • user_id — int
  • channel_id — varchar(255) — Foreign key → channels.channel_id

channel_auction

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

channel_images

  • channel_image_id — 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_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
  • videoTitle — varchar(1000) — NOT NULL
  • videoThumbnailUrl — varchar(2000) — NOT NULL
  • view_count — int — NOT NULL
  • 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 — varchar(2000) — NOT NULL
  • main_thumbnail — varchar(3000) — NOT NULL
  • description — varchar(3000) — NOT NULL
  • view_count — int — NOT NULL
  • hidden_subscriber_count — tinyint — NOT NULL
  • auction_amount — 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
  • partnerId — int — NOT NULL
  • partner_id — int — Foreign key → partners.partner_id

faqs

  • faq_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • title — varchar(300) — NOT NULL
  • description — varchar(2000) — NOT NULL

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 — Foreign key → users.user_id — 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) — NOT NULL

notification

  • notification_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 → users.user_id — 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_number — 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

sell_trade_history

  • trade_history_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • trade_type — enum('sell','sell_cancel','buy','buy_cancel') — NOT NULL
  • traded_quantity — int — NOT NULL
  • traded_price — int — NOT NULL
  • transaction_id — char(36) — Foreign key → sell_transactions.sell_transaction_id — NOT NULL
  • channel_id — varchar(255) — Foreign key → channels.channel_id — NOT NULL

sell_transactions

  • sell_transaction_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
  • traded_quantity — int — NOT NULL
  • order_price — int — NOT NULL
  • transaction_status — enum('ongoing','closed','cancel') — NOT NULL
  • user_id — int — NOT NULL
  • channel_id — varchar(255) — Foreign key → channels.channel_id — NOT NULL

trade_information

  • trade_information_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • start_price — int — NOT NULL
  • end_price — int — NOT NULL
  • max_price — int — NOT NULL
  • min_price — int — NOT NULL
  • traded_quantity — int — NOT NULL
  • channel_id — varchar(255) — Foreign key → channels.channel_id — NOT NULL

trade_rules

  • trade_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') — NOT NULL

trade_rules_items

  • trade_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') — NOT NULL
  • trade_rule_id — int — Foreign key → trade_rules.trade_rule_id — NOT NULL

trade_users

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

users

  • user_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • user_status — enum('active','delete','block') — NOT NULL
  • email — varchar(500) — NOT NULL
  • password — varchar(1000) — NOT NULL
  • phone_number — varchar(30) — NOT NULL
  • name — varchar(100) — NOT NULL
  • nickname — varchar(20) — NOT NULL
  • date_of_birth — varchar(255) — NOT NULL
  • gender — int — NOT NULL
  • roles — enum('admin','user','guest') — NOT NULL
  • marketing_terms — tinyint — NOT NULL
  • walletEntityWalletId — char(36) — Foreign key → wallets.wallet_id
  • notificationEntityNotificationId — int — Foreign key → notification.notification_id

verify_number

  • verify_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • phone — varchar(255) — NOT NULL
  • verify_number — int — NOT NULL

wallet_history

  • wallet_history_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • type — enum('charging','withdrawal','auction','trade_sell','trade_buy','copyright_fee','event','etc') — NOT NULL
  • consume_name — enum('충전','출금','거래 (옥션)'
  • 거래 — (판매)'
  • 거래 — (구매)'
  • etc) — NOT — NOT NULL
  • is_waiting — tinyint — NOT NULL
  • description — varchar(500) — NOT NULL
  • description_additional — varchar(100) — NOT NULL
  • order_quantity — int — NOT NULL
  • order_price — int — NOT NULL
  • traded_quantity — int — NOT NULL
  • variable_amount — int — NOT NULL
  • fee — int — NOT NULL
  • balance — int — NOT NULL
  • wallet_id — char(36) — Foreign key → wallets.wallet_id — NOT NULL

wallet_history_staging

  • wallet_history_staging_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • type — enum('withdrawal','charging') — NOT NULL
  • subtype — enum('waiting','cancel','confirm') — NOT NULL
  • consume_name — enum('출금','충전') — NOT NULL
  • description — varchar(255) — NOT NULL
  • staging_amount — int — NOT NULL
  • fee — int — NOT NULL
  • account_number — varchar(100) — NOT NULL
  • accout_bank_name — varchar(100) — NOT NULL
  • account_owner_name — varchar(100) — NOT NULL
  • wallet_id — char(36) — Foreign key → wallets.wallet_id — NOT NULL

wallet_history_staging_auction

  • wallet_history_staging_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • type — enum('withdrawal','auction','transaction_sale','transaction_purchase') — NOT NULL
  • is_waiting — tinyint — NOT NULL
  • consume_name — enum('출금','거래 (옥션)'
  • 거래 — (판매)'
  • 거래 — (구매)') — NOT NULL
  • staging_amount — int — NOT NULL
  • fee — int — NOT NULL
  • description — varchar(500) — NOT NULL
  • description_additional — varchar(100) — NOT NULL
  • order_quantity — int — NOT NULL
  • order_price — int — NOT NULL
  • traded_quantity — int — NOT NULL
  • wallet_id — char(36) — Foreign key → wallets.wallet_id — NOT NULL
  • auction_id — char(36) — Foreign key → auctions.auction_id — NOT NULL

wallet_history_staging_trade

  • wallet_history_staging_id — int — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • type — enum('withdrawal','auction','transaction_sale','transaction_purchase') — NOT NULL
  • is_waiting — tinyint — NOT NULL
  • consume_name — enum('출금','거래 (옥션)'
  • 거래 — (판매)'
  • 거래 — (구매)') — NOT NULL
  • staging_amount — int — NOT NULL
  • fee — int — NOT NULL
  • description — varchar(500) — NOT NULL
  • description_additional — varchar(100) — NOT NULL
  • order_quantity — int — NOT NULL
  • order_price — int — NOT NULL
  • traded_quantity — int — NOT NULL
  • wallet_id — char(36) — Foreign key → wallets.wallet_id — NOT NULL
  • transaction_id — char(36) — Foreign key → buy_transactions.buy_transaction_id — NOT NULL

wallets

  • wallet_id — char(36) — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)
  • account_number — varchar(100) — NOT NULL
  • accout_bank_name — varchar(100) — NOT NULL
  • account_owner_name — varchar(100) — NOT NULL
  • available_amount — int — NOT NULL
  • staging_amount — int — NOT NULL
  • user_id — int — Foreign key → users.user_id — NOT NULL
  • resident_registration_head — varchar(6) — NOT NULL
  • resident_registration_tail — varchar(7) — NOT NULL