칸그림

테이블 (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)