dd

Tables (36)

ATC_Advisory

    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

      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)

      arrival_departure

        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

        crew

          crew_flight_plan

            crew_organization

              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

              favorite

                flight_path

                  flight_plan

                    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)