test

Tables (50)

auction_product_files

  • auction_product_id — bigint(20) — Foreign key → auction_products.id — NOT NULL
  • file_id — bigint(20)

auction_products

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • created_by — varchar(20)
  • modified_by — varchar(20)
  • auction_status — varchar(10)
  • auctioneer_id — bigint(20)
  • bid_status — varchar(10)
  • estimated_price — bigint(20)
  • item_id — bigint(20)
  • quality_condition — varchar(10)
  • quantity — int(11)
  • successful_bid_price — bigint(20)
  • unit — varchar(10)
  • auction_id — bigint(20) — Foreign key → 경매.id

ban_words

  • id — bigint(20) — Primary key — NOT NULL
  • word — varchar(20) — NOT NULL

basic_infos

  • id — bigint(20) — Primary key — NOT NULL
  • default_delivery_message — varchar(255)
  • fresh_order_delay_days — int(11) — NOT NULL
  • normal_order_delay_days — int(11) — NOT NULL
  • purchase_confirm_days — int(11) — NOT NULL
  • purchase_order_deadline — time

bill_ledgers

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • apply_number — varchar(40)
  • card_name — varchar(20)
  • pay_method — varchar(20)
  • pay_type — varchar(20)
  • payment_amount — bigint(20)
  • payment_name — varchar(255)
  • payment_status — varchar(20)
  • pg_provider — varchar(30)
  • vbank_created_date — datetime(6)
  • vbank_expired_date — datetime(6)
  • vbank_holder — varchar(40)
  • vbank_name — varchar(40)
  • vbank_number — varchar(40)
  • order_id — bigint(20) — Foreign key → orders.id

coupon_policies

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • created_by — varchar(20)
  • modified_by — varchar(20)
  • amount — double — NOT NULL
  • benefit_type — varchar(20) — NOT NULL
  • enabled — bit(1) — NOT NULL
  • expiration_date — int(11) — NOT NULL
  • issue_date — date
  • issue_type — varchar(20) — NOT NULL
  • issued_count — int(11) — NOT NULL
  • name — varchar(255) — NOT NULL
  • policy_status — varchar(20) — NOT NULL
  • target — varchar(20) — NOT NULL

courier_company

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • created_by — varchar(20)
  • modified_by — varchar(20)
  • code — varchar(20) — NOT NULL
  • defaulted — bit(1) — NOT NULL
  • delivery_charge — bigint(20)
  • enabled — bit(1) — NOT NULL
  • name — varchar(20) — NOT NULL
  • tel — varchar(20)

customer_stocks

  • id — bigint(20) — Primary key — NOT NULL
  • customer_id — bigint(20) — NOT NULL
  • quantity — bigint(20) — NOT NULL
  • sale_count — bigint(20) — NOT NULL
  • stock_id — bigint(20) — Foreign key → stocks.id

deliveries

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • company_code — varchar(20)
  • company_name — varchar(20)
  • company_tel — varchar(20)
  • delivery_status — varchar(20) — NOT NULL
  • invoice_number — varchar(40)

evaluations

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • created_by — varchar(20)
  • modified_by — varchar(20)
  • answer — varchar(255) — NOT NULL
  • answer_index — int(11)
  • offer_id — bigint(20) — NOT NULL
  • product_id — bigint(20) — NOT NULL
  • question — varchar(255) — NOT NULL
  • survey_id — bigint(20)
  • review_id — bigint(20) — Foreign key → reviews.id

files

  • id — bigint(20) — Primary key — NOT NULL
  • content_type — varchar(40)
  • extension — varchar(10)
  • file_name — varchar(255)
  • file_path — varchar(255)
  • has_thumbnail — bit(1) — NOT NULL
  • path — varchar(255)
  • save_file_name — varchar(255)
  • size — bigint(20) — NOT NULL
  • thumbnail_path — varchar(255)
  • upload_date — datetime(6)

items

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • created_by — varchar(20)
  • modified_by — varchar(20)
  • category — varchar(10) — NOT NULL
  • code — varchar(6) — NOT NULL
  • name — varchar(50) — NOT NULL
  • unit_id — bigint(20) — Foreign key → units.id — NOT NULL

members

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • email — varchar(40)
  • enabled — bit(1) — NOT NULL
  • last_login_date — datetime(6)
  • name — varchar(20)
  • password — varchar(255)
  • phone — varchar(20)
  • provider — varchar(20)
  • provider_id — varchar(40)
  • registered — bit(1) — NOT NULL
  • user_id — varchar(50)
  • point_id — bigint(20) — Foreign key → points.id

notices

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • created_by — varchar(20)
  • modified_by — varchar(20)
  • contents — longtext
  • enabled — bit(1) — NOT NULL
  • title — varchar(255) — NOT NULL
  • views — int(11) — NOT NULL

order_cancels

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • created_by — varchar(20)
  • modified_by — varchar(20)
  • cancel_status — varchar(20) — NOT NULL
  • reason — varchar(255)
  • order_id — bigint(20) — Foreign key → orders.id — NOT NULL

order_details

  • id — bigint(20) — Primary key — NOT NULL
  • offer_id — bigint(20) — NOT NULL
  • order_detail_number — varchar(20) — NOT NULL
  • order_quantity — int(11) — NOT NULL
  • product_code — varchar(20)
  • product_id — bigint(20) — NOT NULL
  • product_name — varchar(100) — NOT NULL
  • sale_id — bigint(20)
  • sale_title — varchar(255)
  • sequence — int(11)
  • unit_price — bigint(20) — NOT NULL
  • delivery_id — bigint(20) — Foreign key → deliveries.id
  • order_id — bigint(20) — Foreign key → orders.id — NOT NULL

order_returns

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • created_by — varchar(20)
  • modified_by — varchar(20)
  • reason — varchar(255)
  • account_name — varchar(20)
  • account_number — varchar(40)
  • bank_type — varchar(20)
  • refund_amount — bigint(20)
  • refund_status — varchar(20) — NOT NULL
  • refund_type — varchar(20) — NOT NULL
  • return_completed_date — datetime(6)
  • return_status — varchar(20) — NOT NULL
  • order_id — bigint(20) — Foreign key → orders.id — NOT NULL

orders

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • created_by — varchar(20)
  • modified_by — varchar(20)
  • applied_coupon — bit(1) — NOT NULL
  • applied_point — bit(1) — NOT NULL
  • applied_stock — bit(1) — NOT NULL
  • confirm_purchase_at — datetime(6)
  • customer_id — bigint(20)
  • address1 — varchar(100) — NOT NULL
  • address2 — varchar(100)
  • memo — varchar(255)
  • name — varchar(20) — NOT NULL
  • phone1 — varchar(20) — NOT NULL
  • phone2 — varchar(20)
  • zip_code — varchar(10) — NOT NULL
  • discount_amount — bigint(20) — NOT NULL
  • note_for_mng — longtext
  • order_name — varchar(255)
  • order_number — varchar(16) — NOT NULL
  • order_status — varchar(20) — NOT NULL
  • order_type — varchar(20) — NOT NULL
  • orderer_address1 — varchar(100)
  • orderer_address2 — varchar(100)
  • orderer_email — varchar(40)
  • orderer_name — varchar(20)
  • orderer_phone1 — varchar(20)
  • orderer_phone2 — varchar(20)
  • orderer_zip_code — varchar(10)
  • pay_type — varchar(20) — NOT NULL
  • payment_amount — bigint(20) — NOT NULL
  • pg_type — varchar(20) — NOT NULL
  • shipping_fee — bigint(20)
  • total_amount — bigint(20) — NOT NULL
  • used_coupon_id — bigint(20)
  • used_point — bigint(20)

password_reset_token

  • id — bigint(20) — Primary key — NOT NULL
  • expiry_date — datetime(6)
  • token — varchar(255)
  • user_id — bigint(20) — Foreign key → users.id — NOT NULL

payable_ledgers

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • amount — bigint(20)
  • payable_status — varchar(20)
  • reason — varchar(255)
  • receipt_url — varchar(255)
  • tx_id — varchar(100)
  • uid — varchar(50)
  • bill_ledger_id — bigint(20) — Foreign key → bill_ledgers.id

point_histories

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • point — bigint(20)
  • point_type — varchar(20) — NOT NULL
  • point_id — bigint(20) — Foreign key → points.id

point_policies

  • id — bigint(20) — Primary key — NOT NULL
  • accumulate_count — int(11)
  • accumulate_point — bigint(20)
  • amount — double — NOT NULL
  • benefit_type — varchar(20) — NOT NULL
  • enabled — bit(1) — NOT NULL
  • end_date — date
  • name — varchar(255) — NOT NULL
  • policy_status — varchar(20) — NOT NULL
  • start_date — date
  • target — varchar(20) — NOT NULL

points

  • id — bigint(20) — Primary key — NOT NULL
  • point — bigint(20)

products

  • id — bigint(20) — Primary key — NOT NULL
  • base_price — bigint(20)
  • classification_code — varchar(4) — NOT NULL
  • full_code — varchar(10) — NOT NULL
  • classification_name — varchar(10) — NOT NULL
  • standard — varchar(10) — NOT NULL
  • created_by — varchar(20)
  • modified_by — varchar(20)
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • code — varchar(20) — NOT NULL
  • code_composition_name — varchar(100) — NOT NULL
  • code_name — varchar(50) — NOT NULL
  • code_qty — varchar(10) — NOT NULL
  • name — varchar(100) — NOT NULL
  • quantity — int(11)
  • unit_id — bigint(20) — Foreign key → units.id — NOT NULL
  • item_id — bigint(20) — Foreign key → items.id — NOT NULL

products_surveys

  • product_id — bigint(20) — Foreign key → products.id — NOT NULL
  • surveys_id — bigint(20) — Foreign key → surveys.id — NOT NULL

purchase_orders

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • created_by — varchar(20)
  • modified_by — varchar(20)
  • add_ice_pack — bit(1) — NOT NULL
  • code — varchar(20) — NOT NULL
  • customer_id — bigint(20)
  • customer_name — varchar(20)
  • address1 — varchar(100) — NOT NULL
  • address2 — varchar(100)
  • memo — varchar(255)
  • name — varchar(20) — NOT NULL
  • phone1 — varchar(20) — NOT NULL
  • phone2 — varchar(20)
  • zip_code — varchar(10) — NOT NULL
  • offer_id — bigint(20) — NOT NULL
  • order_completed — bit(1) — NOT NULL
  • order_detail_number — varchar(20)
  • order_number — varchar(16)
  • order_type — varchar(20) — NOT NULL
  • orderer_address1 — varchar(100)
  • orderer_address2 — varchar(100)
  • orderer_email — varchar(40)
  • orderer_name — varchar(20)
  • orderer_phone1 — varchar(20)
  • orderer_phone2 — varchar(20)
  • orderer_zip_code — varchar(10)
  • price — bigint(20)
  • product_id — bigint(20) — NOT NULL
  • quantity — int(11) — NOT NULL
  • sale_id — bigint(20) — NOT NULL
  • sequence — int(11) — NOT NULL
  • title — varchar(255)
  • delivery_id — bigint(20) — Foreign key → deliveries.id

purchase_plan

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • created_by — varchar(20)
  • modified_by — varchar(20)
  • amount — bigint(20)
  • auctioneer_id — bigint(20)
  • item_id — bigint(20)
  • quantity — int(11)
  • unit — varchar(10)
  • auction_id — bigint(20) — Foreign key → 경매.id

purchases

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • created_by — varchar(20)
  • modified_by — varchar(20)
  • auctioneer_id — bigint(20)
  • purchase_place_name — varchar(20)
  • purchase_price — bigint(20)
  • purchase_type — int(11) — NOT NULL
  • quality_condition — varchar(10) — NOT NULL
  • quantity — bigint(20) — NOT NULL
  • item_id — bigint(20) — Foreign key → items.id — NOT NULL
  • unit_id — bigint(20) — Foreign key → units.id — NOT NULL

purchases_files

  • purchase_id — bigint(20) — Foreign key → purchases.id — NOT NULL
  • file_id — bigint(20) — Foreign key → files.id — NOT NULL

qna

  • id — bigint(20) — Primary key — NOT NULL
  • answer — varchar(255)
  • answered_by — varchar(20)
  • answered_date — datetime(6)
  • created_by — varchar(20)
  • created_date — datetime(6)
  • question — varchar(255) — NOT NULL
  • question_status — varchar(20) — NOT NULL
  • sale_id — bigint(20) — NOT NULL

reasons

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • created_by — varchar(20)
  • modified_by — varchar(20)
  • name — varchar(255) — NOT NULL
  • order_number — int(11)
  • reason_type — varchar(10) — NOT NULL

review_files

  • review_id — bigint(20) — Foreign key → reviews.id — NOT NULL
  • files — varchar(255)

reviews

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • created_by — varchar(20)
  • modified_by — varchar(20)
  • contents — varchar(255) — NOT NULL
  • displayed — bit(1) — NOT NULL
  • offer_id — bigint(20) — NOT NULL
  • product_id — bigint(20) — NOT NULL
  • sale_id — bigint(20) — NOT NULL
  • star — int(11) — NOT NULL

roles

  • role_id — bigint(20) — Primary key — NOT NULL
  • code — varchar(20) — NOT NULL
  • name — varchar(20) — NOT NULL

sales

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • created_by — varchar(20)
  • modified_by — varchar(20)
  • category — varchar(20) — NOT NULL
  • contents — longtext
  • etc_guide — longtext
  • notification — bit(1) — NOT NULL
  • processed_company_id — bigint(20)
  • publish_date — date
  • sale_status — varchar(20) — NOT NULL
  • sale_type — varchar(20) — NOT NULL
  • sales_end_date — datetime(6)
  • sales_start_date — datetime(6)
  • thumbnail — varchar(255)
  • title — varchar(255) — NOT NULL

settle_customer_deposits

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • deposit — bigint(20) — NOT NULL
  • deposit_date — date
  • memo — varchar(255)
  • settle_by_customer_id — bigint(20) — NOT NULL

settle_customers

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • created_by — varchar(20)
  • modified_by — varchar(20)
  • balance — bigint(20) — NOT NULL
  • customer_id — bigint(20) — NOT NULL
  • deposit — bigint(20) — NOT NULL
  • settle_status — int(11) — NOT NULL
  • total_order_amount — bigint(20) — NOT NULL
  • total_order_quantity — bigint(20) — NOT NULL
  • settle_id — bigint(20) — Foreign key → settlements.id — NOT NULL

settlements

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • created_by — varchar(20)
  • modified_by — varchar(20)
  • from_date — date
  • settle_deadline — date
  • to_date — date

shipping_addresses

  • id — bigint(20) — Primary key — NOT NULL
  • address1 — varchar(100)
  • address2 — varchar(100)
  • is_default — bit(1) — NOT NULL
  • memo — varchar(255)
  • name — varchar(20)
  • phone1 — varchar(20)
  • phone2 — varchar(20)
  • zip_code — varchar(10)
  • member_id — bigint(20) — Foreign key → members.id

stocks

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • customer_quota — bigint(20) — NOT NULL
  • disposal_quantity — bigint(20) — NOT NULL
  • stock_quantity — bigint(20) — NOT NULL
  • total_quantity — bigint(20) — NOT NULL

surveys

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • created_by — varchar(20)
  • modified_by — varchar(20)
  • answer1 — varchar(255) — NOT NULL
  • answer2 — varchar(255) — NOT NULL
  • answer3 — varchar(255) — NOT NULL
  • question — varchar(255) — NOT NULL

temp_order_stock

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • offer_id — bigint(20) — NOT NULL
  • order_detail_number — varchar(20) — NOT NULL
  • order_id — bigint(20)
  • order_number — varchar(16) — NOT NULL
  • order_quantity — int(11) — NOT NULL
  • pay_type — int(11)

templates

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • created_by — varchar(20)
  • modified_by — varchar(20)
  • contents — longtext
  • enabled — bit(1) — NOT NULL
  • template_type — varchar(10) — NOT NULL
  • title — varchar(255) — NOT NULL

units

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • created_by — varchar(20)
  • modified_by — varchar(20)
  • code — varchar(10) — NOT NULL
  • en_title — varchar(20)
  • enabled — bit(1) — NOT NULL
  • title — varchar(20) — NOT NULL

users

  • id — bigint(20) — Primary key — NOT NULL
  • email — varchar(40)
  • enabled — bit(1) — NOT NULL
  • fcm_token — varchar(255)
  • name — varchar(20) — NOT NULL
  • password — varchar(255) — NOT NULL
  • phone — varchar(20)
  • refresh_token — varchar(255)
  • user_id — varchar(20) — NOT NULL

users_roles

  • user_id — bigint(20) — Foreign key → users.id — NOT NULL
  • role_id — bigint(20) — Foreign key → roles.role_id — NOT NULL

verification_tokens

  • id — bigint(20) — Primary key — NOT NULL
  • expiry_date — datetime(6)
  • token — varchar(255)
  • user_id — bigint(20) — Foreign key → users.id — NOT NULL

work_requests

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • created_by — varchar(20)
  • modified_by — varchar(20)
  • sale_id — bigint(20) — NOT NULL
  • user_id — bigint(20) — NOT NULL

works

  • id — bigint(20) — Primary key — NOT NULL
  • purchase_id — bigint(20) — NOT NULL
  • work_status — varchar(20) — NOT NULL
  • work_request_id — bigint(20) — Foreign key → work_requests.id — NOT NULL

경매 (auctions)

  • id — bigint(20) — Primary key — NOT NULL
  • 생성일 (created_date) — datetime(6)
  • modified_date — datetime(6)
  • created_by — varchar(20)
  • modified_by — varchar(20)