nice

Tables (7)

handle

  • handle_id — INT — Primary key — NOT NULL
  • handle_item — VARCHAR(45)

reporting_agency

  • reporting_agency_id — INT — Primary key — NOT NULL
  • name — VARCHAR(45)
  • tel_num — VARCHAR(45)

sales_method

  • sales_method_id — INT — Primary key — NOT NULL
  • name — VARCHAR(45)

telecommunication_business

  • telecommunication_business_id — INT — Primary key — NOT NULL
  • telecommunication_business_number — INT
  • reporting_agency_id — INT — Foreign key → reporting_agency.reporting_agency_id — NOT NULL
  • shop_name — VARCHAR(45) — NOT NULL
  • registration_num — VARCHAR(45) — NOT NULL — 사업자등록번호
  • corporate — INT — NOT NULL — 법인여부
  • director — VARCHAR(45) — NOT NULL
  • tel_num — VARCHAR(45)
  • email — VARCHAR(45)
  • report_date — DATE — NOT NULL
  • business_address — VARCHAR(45)
  • business_address_street — VARCHAR(45)
  • business_status — VARCHAR(45) — NOT NULL
  • internet_domain — VARCHAR(45)
  • hostserver_addreses — VARCHAR(45)

telecommunication_business_and_handle

  • telecommunication_business_id — INT — Foreign key → telecommunication_business.telecommunication_business_id — NOT NULL
  • handle_id — INT — Foreign key → handle.handle_id — NOT NULL

telecommunication_business_and_sales_method

  • telecommunication_business_id — INT — Foreign key → telecommunication_business.telecommunication_business_id — NOT NULL
  • sales_method_id — INT — Foreign key → sales_method.sales_method_id — NOT NULL

update_log

  • registration_num — VARCHAR(45) — Foreign key → telecommunication_business.registration_num — NOT NULL
  • content — TEXT — NOT NULL
  • ldate — DATE — NOT NULL