사본
테이블 (39)
ShippingEvent
- shipping_evnet_id — bigint — 기본 키 — NOT NULL
- shipping_id — bigint — NOT NULL
- shipping_event_type — enum
- shipping_event_status — enum
- shipping_event_description — varchar(100)
- created_at — timestamp
- updated_at — timestamp
- shipping_event_processed_by — enum
User
- user_id — varchar(60)
- user_email — varchar(60)
- user_pw — varchar(60)
- pre_pw — varchar(60)
- user_name — varchar(30)
- user_RR_number — varchar(14)
- user_phone_number — varchar(30)
- user_address — varchar(100)
- user_gender — check('M', 'F')
- user_registration_at — timestamp
- user_id_creation_at — timestamp
- sms_marketing_recieved_status — char(1)
- email_marketing_recieved_status — char(1)
- customer_status — enum
- is_user_withdrawal — boolean
- user_withdrawal_at — timestamp
- user_withdrawal_reason — varchar(300)
- created_at — timestamp
- updated_at — timestamp
- role — enum
business_info
- business_info_id — bigint — 기본 키 — NOT NULL
- company_name — varchar(30)
- ceo_name — varchar(30)
- main_phone — varchar(20)
- company_address — varchar(200)
- business_registration_number — varchar(60)
- telecom_sales_registration_number — varchar(60)
- privacy_officer — varchar(30)
- customer_service_phone — varchar(20)
- company_bank_account_number — varchar(60)
- company_introduction — text
- terms_of_service — text
- privacy_policy — text
- user_guide — text
- created_at — timestamp
- deleted_at — timestamp
cart
- cart_id — bigint — 기본 키 — NOT NULL
- item_id — bigint — NOT NULL
- user_id — varchar(60)
- quantity — int
- input_at — timestamp
- created_at — timestamp
- updated_at — timestamp
category
- category_id — bigint — 기본 키 — NOT NULL
- category_id2 — bigint — NOT NULL
- name — varchar(10)
- depth — int
claim
- claim_id — bigint — 기본 키 — NOT NULL
- user_id — varchar(60)
- order_item_id — bigint — NOT NULL
- employee_id — bigint — NOT NULL
- title — varchar(30)
- type — enum
- detail — varchar(100)
- status — enum
- image_file_url_1 — varchar(30)
- image_file_url_2 — varchar(30)
- image_file_url_3 — varchar(30)
- image_file_url_4 — varchar(30)
- request_reason — enum
- rejection_reason — enum
- created_at — timestamp
- updated_at — timestamp
- shipping_evnet_id — bigint — NOT NULL
code
- code_id — bigint — 기본 키 — NOT NULL
- code_group_id — varchar(50) — NOT NULL
- code_name — varchar(100)
- 취소 — 등
- code_value — varchar(50)
- CANCEL — 등
- code_description — varchar(200)
- sort_order — number
- use_status — boolean
- created_at — timestamp
- deleted_at — timestamp
code_group
- code_group_id — varchar(50) — 기본 키 — NOT NULL
- code_group_name — varchar(100)
- 클레임 — 종류
- 주문 — 상태
- code_group_description — varchar(200)
- sort_order — number
- use_status — boolean
- created_at — timestamp
- deleted_at — timestamp
coupon
- coupon_id — bigint — 기본 키 — NOT NULL
- coupon_name — varchar(50)
- coupon_number_check — varchar(30)
- issued_quantity — number(3)
- coupon_amount — number(6)
- issued_date — timestamp
- created_at — timestamp
- updated_at — timestamp
customer_coupon
- customer_coupon_id — bigint — 기본 키 — NOT NULL
- user_id — varchar(60)
- coupon_id — bigint — NOT NULL
- issued_date — timestamp
- used_date — timestamp
delivery_destination
- delivery_id — bigint — 기본 키 — NOT NULL
- user_id — varchar(60)
- alias — varchar(30)
- receiptor_name — varchar(30)
- receiptor_phone_number — varchar(30)
- address — varchar(100)
- detailed_address — varchar(100)
- is_default_address — boolaen
- is_delivery_destination — boolean
- created_at — timestamp
- updated_at — timestamp
employee
- employee_id — bigint — 기본 키 — NOT NULL
- employee_name — varchar(10)
- employee_role — enum
- employee_email — varchar(30)
- employee_status — enum
grade_change_history
- grade_history_id — bigint — 기본 키 — NOT NULL
- user_grade_id — bigint — NOT NULL
- grade_change_at — timestamp
- created_at — timestamp
- updated_at — timestamp
inspection
- inspection_id — bigint — 기본 키 — NOT NULL
- user_id — varchar(60)
- stocktransaction_history_id — bigint — NOT NULL
- order_item_id — bigint — NOT NULL
- employee_id — bigint — NOT NULL
- state — enum
- type — enum
- content — text
- image_url — varchar(255)
- approved_quantity — int
- rejected_quantity — int
- date — date
- created_at — timestamp
- updated_at — timestamp
inventory
- inventory_id — bigint — 기본 키 — NOT NULL
- item_id — bigint — NOT NULL
- quantity — int
- created_at — timestamp
- updated_at — timestamp
inventory_history
- inventory_history_id — bigint — 기본 키 — NOT NULL
- inventory_id — bigint — NOT NULL
- location_code — varchar(50)
- zone — varchar(50)
- rack — varchar(50)
- shelf — varchar(50)
- description — text
- created_at — timestamp
- updated_at — timestamp
item
- item_id — bigint — 기본 키 — NOT NULL
- category_id — bigint — NOT NULL
- name — varchar(255)
- image — varchar(255)
- description — text
- price — DECIMAL(10,2)
- status — enum
- grade — enum
- manufacture_country — varchar(100)
- is_best_seller — boolean
- created_at — tiemstamp
- updated_at — timestamp
login_logout_history
- login_logout_history_id — bigint — 기본 키 — NOT NULL
- user_id — varchar(60)
- login_at — timestamp
- logout_at — timestamp
- access_nation — enum
- login_ip_address — varchar(30)
- login_device_info — device_info
- login_failure_at — timestamp
- login_failure_reason — enum
- created_at — timestamp
- updated_at — timestamp
notice
- notice_id — bigint — 기본 키 — NOT NULL
- title — varchar(100)
- content — text
- view_count — int
- is_visible — boolean
- start_date — timestamp
- end_date — timestamp
- created_at — timestamp
- updated_at — timestamp
option
- option_id — bigint — 기본 키 — NOT NULL
- item_id — bigint — NOT NULL
- color — vharchar(50)
- size — varchar(50)
- is_required — boolean
- created_at — timestamp
- updated_at — timestamp
order
- order_id — bigint — 기본 키 — NOT NULL
- user_id — varchar(60)
- order_status — enum
- shipping_amount — decimal(10, 2)
- shipping_fee — decimal(10, 2)
- created_at — timestamp
- updated_at — timestamp
order_item
- order_item_id — bigint — 기본 키 — NOT NULL
- user_id — varchar(60)
- order_id — bigint — NOT NULL
- item_id — bigint — NOT NULL
- order_item_status — enum
- delay_reason — enum
- order_item_price — decimal(10, 2)
order_item_history
- order_item_history_id — bigint — 기본 키 — NOT NULL
- user_id — varchar(60)
- order_item_id — bigint — NOT NULL
- order_status — enum
- created_at — timestamp
payment_history
- payment_history_id — bigint — 기본 키 — NOT NULL
- user_id — varchar(60)
- order_id — bigint — NOT NULL
- payment_key — varchar(255)
- payment_method_type — enum
- result_code — enum
- requested_at — timestamp
- approved_at — timestamp
- receipt_url — varchar(255)
- card_issuer_code — enum
- card_acquirer_code — enum
- card_number — varchar(255)
- installment_months — int
- va_account_number — varchar(255)
- va_bank_code — enum
- transfer_account_number — varchar(255)
- transfer_bank_code — enum
- order_amount — decimal(10, 2)
- coupon_discount_amount — decimal(10, 2)
- point_amount — decimal(10, 2)
- membership_discount_amount — decimal(10, 2)
- delivery_fee — decimal(10, 2)
- final_paid_amount — decimal(10, 2)
- refund_requested — boolean
- refund_requested_at — timestamp
- refund_status — enum
- refund_reason — varchar(255)
- refund_rejected_reason — varchar(255)
- refund_amount — decimal(10, 2)
payment_method
- payment_method_id — bigint — 기본 키 — NOT NULL
- user_id — varchar(60)
- payment_method — enum
- card_company_code — varchar(60)
- card_number — varchar(255)
- bank_code — enum
- account_number — varchar(60)
- user_cash_receipt_number — varchar(60)
- user_taxpayer_identification_number — varchar(60)
- billing_key — varchar(255)
- is_default_payment_method — boolean
- is_pay_available — boolean
- pay_deny_reason — enum
- owner_type — enum
- created_at — timestamp
- updated_at — timestamp
point
- point_id — bigint — 기본 키 — NOT NULL
- user_id — varchar(60)
- point_status — enum
- point_balance — number(6)
- created_at — timestamp
- updated_at — timestamp
point_history
- point_history_id — bigint — 기본 키 — NOT NULL
- user_id — varchar(60)
- point_id — bigint — NOT NULL
- changed_date — timestamp
- created_at — timestamp
- updated_at — timestamp
product_answer
- product_answer_id — bigint — 기본 키 — NOT NULL
- user_id — varchar(60)
- product_question_id — bigint — NOT NULL
- employee_id — bigint — NOT NULL
- content — text
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
product_question
- product_question_id — bigint — 기본 키 — NOT NULL
- user_id — varchar(60)
- item_id — bigint — NOT NULL
- image_url — varchar(255)
- question_type — enum
- title — varchar(255)
- content — text
- is_private — boolean
- is_answered — boolean
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
refund
- refund_id — bigint — 기본 키 — NOT NULL
- user_id — varchar(60)
- payment_history_id — bigint — NOT NULL
- order_item_id — bigint — NOT NULL
- updated_at — timestamp
- created_at — timestamp
- refund_account_bank_code — varchar(255)
- refund_account_number — varchar(255)
- refund_holder_name — varchar(10)
review
- review_id — bigint — 기본 키 — NOT NULL
- user_id — varchar(60)
- item_id — bigint — NOT NULL
- rating — int
- title — vharchar(50)
- content — text
- image_url — varchar(255)
- view — int
- is_hidden — boolean
- created_at — timestamp
- updated_at — timestamp
shipping
- shipping_id — bigint — 기본 키 — NOT NULL
- order_item_id — bigint — NOT NULL
- shipping_type — enum
- shipping_method — enum
shipping_history
- shipping_history_id — bigint — 기본 키 — NOT NULL
- shipping_id — bigint — NOT NULL
- shipping_status — enum
- shipping_location_name — varchar(20)
- shipping_location_type — enum
- memo — varchar(100)
- created_at — timestamp
- updated_at — timestamp
stocktransaction_history
- stocktransaction_history_id — bigint — 기본 키 — NOT NULL
- inventory_id — bigint — NOT NULL
- vendor_item_id — bigint — NOT NULL
- quantity_change — int
- inspected — boolean
- delivery_driver_name — varchar(255)
- applied_to_stock — boolean
- change_date — date
- applied_at — timestamp
- created_at — timestamp
- updated_at — timestamp
user_grade
- user_grade_id — bigint — 기본 키 — NOT NULL
- user_id — varchar(60)
- user_grade — enum
- grade_benefit — text
- grade_detail — text
- promotion_condition — text
- demotion_condition — text
- created_at — timestamp
- updated_at — timestamp
vendor
- vendor_id — bigint — 기본 키 — NOT NULL
- business_number — varchar(50)
- name — varchar(50)
- phone_number — varchar(50)
- email — varchar(50)
- address — varchar(50)
- created_at — timestamp
- updated_at — timestamp
vendor_item
- vendor_item_id — bigint — 기본 키 — NOT NULL
- item_id — bigint — NOT NULL
- partner — bigint — NOT NULL
- price — DECIMAL(10, 2)
- created_at — timestamp
- updated_at — timestamp
vendor_manager
- vendor_manager_id — bigint — 기본 키 — NOT NULL
- vendor_id — bigint — NOT NULL
- name — varchar(50)
- position — varchar(50)
- phone_number — varchar(50)
- email — varchar(50)
- address — varchar(50)
- created_at — timestamp
- updated_at — timestamp
wish_list
- wish_list_id — bigint — 기본 키 — NOT NULL
- user_id — varchar(60)
- cart_id — bigint — NOT NULL
- keep_at — timestamp
- created_at — timestamp
- updated_at — timestamp