dd
Tables (36)
PAX
- PAX_id — int — Primary key — NOT NULL
- PNR_id — int — Foreign key → PNR.PNR_id — NOT NULL
- name — VARCHAR(45)
- age — int
- cellphone — VARCHAR(13)
PNR
- PNR_id — int — Primary key — NOT NULL
- customer_no — int — NOT NULL
- reserve_time — DATETIME
SEG
- SEG_id — int — Primary key — NOT NULL
- PNR_id — int — Foreign key → PNR.PNR_id — NOT NULL
- SEG_type_id — int — NOT NULL
SEG_type
- SEG_type_id — int — Primary key — NOT NULL
- SEG_type_value — VARCHAR(45)
SSR
- SEG_id — int — Foreign key → SEG.SEG_id — NOT NULL
- PAX_id — int — Foreign key → PAX.PAX_id — NOT NULL
- SSR_type_id — int — NOT NULL
SSR_type
- SSR_type_id — int — Primary key — NOT NULL
- SSR_type_value — VARCHAR(45)
Untitled
- Key — VARCHAR(255) — Primary key — NOT NULL
- Field — VARCHAR(255)
accessory
- accessory_id — int — Foreign key → product.product_id — NOT NULL
affilate_product
- affilate_product_id — int — Foreign key → product.product_id — NOT NULL
airline_ticket
- airline_ticket_id — int — Foreign key → product.product_id — NOT NULL
airport
- name — VARCHAR(45)
- IATA_code — VARCHAR(3)
- IACO_code — VARCHAR(45)
combined_product
- combined_product_id — int — Foreign key → product.product_id — NOT NULL
combined_product_detail
- combined_product_id — int — Foreign key → combined_product.combined_product_id — NOT NULL
- airline_ticket_id — int — NOT NULL
- extra_service_id — int — NOT NULL
- affilate_product_id — int — NOT NULL
- accessory_id — int — NOT NULL
corporation_benefit
- customer_no — int — Foreign key → corporation_customer.customer_no — NOT NULL
- Field — VARCHAR(45)
corporation_customer
- customer_no — int — Foreign key → customer.customer_no — NOT NULL
- represent_name — VARCHAR(45)
- company_registration_no — VARCHAR(45)
- company_code — VARCHAR(45) — NOT NULL
corporation_customer_employee
- customer_no — int — Foreign key → individual_customer.customer_no — NOT NULL
- customer_no2 — int — Foreign key → corporation_customer.customer_no — NOT NULL
customer
- customer_no — int — Primary key — NOT NULL
- name — VARCHAR(45)
- cellphone — VARCHAR(13)
customer_identification
- customer_no — int — Foreign key → customer.customer_no — NOT NULL
- passport — VARCHAR(45)
- registration_card — VARCHAR(45)
extra_service
- extra_service_id — int — Foreign key → product.product_id — NOT NULL
- Key — VARCHAR(255) — NOT NULL
extra_service_reserved
- extra_service_id — int — Primary key — NOT NULL
- SEG_id — int — Foreign key → SEG.SEG_id — NOT NULL
- PAX_id — int — Foreign key → PAX.PAX_id — NOT NULL
- product_key — int — Foreign key → product.product_id — NOT NULL
full_member
- customer_no — int — Foreign key → individual_customer.customer_no — NOT NULL
- name — VARCHAR(45)
- id — VARCHAR(45)
- password — VARCHAR(45)
individual_customer
- customer_no — int — Foreign key → customer.customer_no — NOT NULL
passport
- passport_no — int — Primary key — NOT NULL
product
- product_id — int — Primary key — NOT NULL
- name — VARCHAR(45)
- price — int
- Field — TEXT
runway
- id — int — Primary key — NOT NULL
simple_member
- customer_no — int — Foreign key → individual_customer.customer_no — NOT NULL
- Key — int — NOT NULL
simple_member_company_info
- Key — int — Primary key — NOT NULL
- Field — VARCHAR(45)