서울시과제
테이블 (13)
admin_users
- num — INT(11) — 기본 키 — NOT NULL
- admin_id — VARCHAR(50) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- created_at — DATETIME
anomaly_data
- anomaly_date — DATE — 기본 키 — NOT NULL
- user_id — VARCHAR(50) — 외래 키 → company_members.user_id — NOT NULL
company_members
- user_id — VARCHAR(50) — 기본 키 — NOT NULL
- password — VARCHAR(255) — NOT NULL
- business_number — VARCHAR(20)
- ceo_name — VARCHAR(100)
- ceo_contact — VARCHAR(20)
- ceo_email — VARCHAR(100)
- business_license — VARCHAR(1000)
- member_type — VARCHAR(50)
- website — VARCHAR(255)
- brand_name — VARCHAR(100)
- settlement_account_bank — VARCHAR(30)
- settlement_account_number — VARCHAR(30)
- settlement_account_copy — VARCHAR(1000)
- registration_date — DATE
- membership_level — VARCHAR(50)
- status — VARCHAR(255)
- reject_reason — TEXT
faq
- num — INT(11) — 기본 키 — NOT NULL
- admin_id — INT(11) — 외래 키 → admin_users.num — NOT NULL
- category — VARCHAR(100)
- title — VARCHAR(255) — NOT NULL
- created_at — DATETIME
- contents — TEXT
fee
- user_id — VARCHAR(50) — 외래 키 → company_members.user_id — NOT NULL
- brand_name — VARCHAR(50)
- shopping_mall — VARCHAR(50)
- k_fee — VARCHAR(50)
monthly_settlements
- num — INT(11) — 기본 키 — NOT NULL
- member_id — VARCHAR(50) — 외래 키 → company_members.user_id — NOT NULL
- uploaded_at — DATETIME — NOT NULL
- settlement_month — DATE — NOT NULL
- channel — VARCHAR(30) — NOT NULL
- order_number — VARCHAR(50)
- customer_name — VARCHAR(100)
- product_code — VARCHAR(100)
- product_name — TEXT
- qty — INT(11)
- sales_price — INT(11)
- shipping_price — INT(11)
- commission_rate — DECIMAL(5,4)
- settlement_price — INT(11)
- brand_name — VARCHAR(50)
monthly_total
- num — INT(11) — 기본 키 — NOT NULL
- member_id — VARCHAR(50) — 외래 키 → company_members.user_id — NOT NULL
- brand_name — VARCHAR(50)
- channel — VARCHAR(30) — NOT NULL
- total_sales — INT(11)
- total_shipping — INT(11)
- commission_rate — VARCHAR(10)
- total_settlement — INT(11)
- adjustment — INT(11)
- final_settlement — INT(11)
- excel_filename — VARCHAR(255)
- uploaded_at — DATETIME — NOT NULL
- settlement_month — DATE — NOT NULL
notices
- num — INT(11) — 기본 키 — NOT NULL
- admin_id — INT(11) — 외래 키 → admin_users.num — NOT NULL
- title — VARCHAR(255) — NOT NULL
- created_at — DATETIME
- attachment — VARCHAR(1000)
- contents — TEXT
pre_settlements
- num — INT(11) — 기본 키 — NOT NULL
- member_id — VARCHAR(50) — 외래 키 → company_members.user_id — NOT NULL
- shopping_mall — VARCHAR(100)
- sales_amount — DECIMAL(15,2)
- refund_amount — DECIMAL(15,2)
- net_sales_amount — DECIMAL(15,2)
- shipping_fee — DECIMAL(15,2)
- channel_commission — DECIMAL(15,2)
- pre_settlement_amount — DECIMAL(15,2)
- application_amount — DECIMAL(15,2)
- pre_settlement_date — DATE — NOT NULL
- status — VARCHAR(30) — NOT NULL
- reject_reason — TEXT
- pre_settlement_updated — DATETIME — NOT NULL
- created_at — DATETIME
- brand_name — VARCHAR(50)
product_info
- num — INT(11) — 기본 키 — NOT NULL
- shipment_request_date — DATE
- order_number — VARCHAR(50)
- product_code — VARCHAR(50)
- shopping_mall — VARCHAR(100)
- brand_name — VARCHAR(100)
- p_name — VARCHAR(50) — NOT NULL
- order_date — DATE
- product_name — VARCHAR(255)
- option_name — VARCHAR(255)
- quantity — INT(11)
- orderer_name — VARCHAR(100)
- buyer_contact — VARCHAR(20)
- receiver_name — VARCHAR(100)
- receiver_contact — VARCHAR(20)
- receiver_zipcode — VARCHAR(10)
- shipping_address — VARCHAR(1000)
- shipping_message — VARCHAR(1000)
- sale_price — DECIMAL(10,2)
- payment_amount — DECIMAL(10,2)
- claim_type — VARCHAR(50)
- claim_date — DATE
- claim_processed_date — DATE
- claim_status — VARCHAR(50)
- order_status — VARCHAR(50)
qna
- num — INT(11) — 기본 키 — NOT NULL
- member_id — VARCHAR(50) — 외래 키 → company_members.user_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- created_at — DATETIME
- contents — TEXT
- admin_id — VARCHAR(50)
- answer_date — DATETIME
- answer — TEXT
return_rate
- user_id — VARCHAR(50) — 외래 키 → company_members.user_id — NOT NULL
- brand_name — VARCHAR(50)
- return_date — DATE
- return_rate — VARCHAR(100) — NOT NULL
sales_info
- num — INT(11) — 기본 키 — NOT NULL
- member_id — VARCHAR(50) — NOT NULL
- brand_name — VARCHAR(100)
- customer_name — VARCHAR(100)
- product_code — VARCHAR(50)
- product_name — VARCHAR(255)
- quantity — INT(11)
- sale_price — DECIMAL(10,2)
- shipping_fee — DECIMAL(10,2)
- commission_fee — DECIMAL(10,2)
- settlement_amount — DECIMAL(10,2)