5조 실전프로젝트

테이블 (3)

seoul_online_shopping_mall_status (V.0.0.02)

  • id (PK) — Long — 기본 키 — NOT NULL
  • businessName (Field) — String
  • mall_name (Field2) — String
  • domain_name (Field3) — String
  • phone_number (Field4) — String
  • operator_email (Field5) — String
  • sales_registration_number (Field6) — String
  • business_type (Field7) — String
  • initial_report_date (Field8) — String
  • company_address (Field9) — String
  • business_status (Field10) — String
  • overall_evaluation (Field11) — String
  • business_info_display_evaluation (Field12) — String
  • withdrawal_right_evaluation (Field13) — String
  • payment_method_evaluation (Field14) — String
  • terms_of_service_evaluation (Field15) — String
  • personal_info_security_evaluation (Field16) — String
  • main_products (Field17) — String
  • withdrawal_possibility (Field18) — String
  • required_initial_screen_items (Field19) — String
  • payment_methods (Field20) — String
  • compliance_with_terms_of_service (Field21) — String
  • personal_info_handling_policy (Field22) — String
  • request_for_additional_personal_info (Field23) — String
  • purchase_safety_service (Field24) — String
  • security_server_installation (Field25) — String
  • certification_mark (Field26) — String
  • expected_delivery_date (Field27) — String
  • withdrawal_shipping_cost_burden (Field28) — String
  • customer_complaint_board_operation (Field29) — String
  • membership_withdrawal_method (Field30) — String
  • site_establishment_year (Field31) — String
  • monitoring_date (Field32) — String

stores (V.0.0.1)

  • id (Key) — Long — 기본 키 — NOT NULL
  • companyName (Field) — String
  • storeName (Field2) — String
  • rating (Field3) — Int
  • monitoringDate (Field4) — LocalDate
  • status (Field5) — String

stores (V.0.0.2)

  • id (PK) — Long — 기본 키 — NOT NULL
  • companyName (Field) — String
  • storeName (Field2) — String
  • rating (Field3) — Int
  • monitoringDate (Field4) — LocalDate
  • status (Field5) — String
  • evaluation (Field6) — String