서울시과제

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