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)