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