칸그림
테이블 (8)
company_members
- num — int(11) — 기본 키 — NOT NULL
- 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 — varchar(30)
- settlement_account_copy — varchar(1000)
- registration_date — date
- membership_level — varchar(50)
- status — varchar(255)
faq
- num — int(11) — 기본 키 — NOT NULL
- member_id — int(11) — 외래 키 → company_members.num — NOT NULL
- category — varchar(100)
- title — varchar(255) — NOT NULL
- created_at — datetime
- contents — text
monthly_settlements
- num — int(11) — 기본 키 — NOT NULL
- member_id — int(11) — 외래 키 → company_members.num — NOT NULL
- settlement_date — date — NOT NULL
- brand_name — varchar(100)
- total_sales_amount — decimal(15,2)
- net_sales_amount — decimal(15,2)
- channel_commission — decimal(15,2)
- pre_settlement_amount — decimal(15,2)
- final_settlement_amount — decimal(15,2)
notices
- num — int(11) — 기본 키 — NOT NULL
- member_id — int(11) — 외래 키 → company_members.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 — int(11) — 외래 키 → company_members.num — NOT NULL
- brand_name — varchar(100)
- 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)
- pre_settlement_date — date — NOT NULL
- status — varchar(30) — NOT NULL
product_info
- num — int(11) — 기본 키 — NOT NULL
- member_id — int(11) — 외래 키 → company_members.num — NOT NULL
- shipment_request_date — date
- order_number — varchar(50)
- product_code — varchar(50)
- shopping_mall — varchar(100)
- brand_name — varchar(100)
- 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
- order_status — varchar(50)
qna
- num — int(11) — 기본 키 — NOT NULL
- member_id — int(11) — 외래 키 → company_members.num — NOT NULL
- title — varchar(255) — NOT NULL
- created_at — datetime
- contents — text
- answer_member_id — int(11)
- answer_date — datetime
- answer — text
sales_info
- num — int(11) — 기본 키 — NOT NULL
- member_id — int(11) — 외래 키 → company_members.num — 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)