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