BASS(1.0)

Wordpress ERD

Tables (10)

tATR

  • atr_code — varchar(20) — Primary key — NOT NULL
  • atr_name — varchar(50) — NOT NULL
  • atr_address — varchar(20) — NOT NULL
  • atr_line — varchar(50) — NOT NULL
  • atr_location — varchar(50) — NOT NULL
  • atr_use — bit — NOT NULL
  • plc_code — varchar(20) — Foreign key → tPLC.plc_guid — NOT NULL

tBagSrcMsg

  • bsm_code — varchar(20) — Primary key — NOT NULL
  • fn_name — char(6) — NOT NULL
  • barcode_number — varchar(20) — NOT NULL
  • publish_datetime — datetime — NOT NULL
  • bsm_destination — char(10) — NOT NULL
  • boarding_datetime — datetime — NOT NULL
  • departure_time — datetime — NOT NULL

tCarousel

  • carousel_code — varchar(20) — Primary key — NOT NULL
  • carousel_name — varchar(50) — NOT NULL
  • carousel_use — bit — NOT NULL

tComCodeM

  • code_category — varchar(20) — Primary key — NOT NULL
  • category_name — varchar(20) — NOT NULL

tDeviceParts

  • parts_code — varchar(20) — Primary key — NOT NULL
  • parts_name — varchar(50) — NOT NULL
  • parts_manufacturer — varchar(50) — NOT NULL
  • input_datetime — datetime — NOT NULL
  • parts_status — varchar(20) — NOT NULL
  • user_code — varchar(20) — Foreign key → tUsers.user_guid — NOT NULL

tFlightNumberInfo

  • fn_code — varchar(20) — Primary key — NOT NULL
  • fn_name — char(6) — Primary key — NOT NULL
  • fn_airline — varchar(20) — NOT NULL
  • carousel_code — varchar(20) — Foreign key → tCarousel.carousel_code — NOT NULL

tNavigation

  • atr_code — varchar(20) — Foreign key → tATR.atr_code — NOT NULL
  • carousel_code — varchar(20) — Foreign key → tCarousel.carousel_code — NOT NULL
  • plc_control — bit — NOT NULL

tPLC

  • plc_guid — varchar(20) — Primary key — NOT NULL
  • plc_name — varchar(50) — NOT NULL
  • plc_ip_addr — varchar(20) — NOT NULL
  • plc_line — varchar(50) — NOT NULL
  • plc_location — varchar(50) — NOT NULL
  • plc_use — bit — NOT NULL

tPLCMap

  • var_addr — varchar(20) — Primary key — NOT NULL
  • plc_guid — varchar(20) — Foreign key → tPLC.plc_guid — NOT NULL
  • var_info — varchar(20) — NOT NULL

tUsers

  • user_guid — varchar(20) — Primary key — NOT NULL
  • user_id — varchar(60) — NOT NULL
  • user_pass — varchar(255) — NOT NULL
  • user_name — varchar(50) — NOT NULL
  • insert_user — varchar(20) — NOT NULL
  • insert_datetime — datetime — NOT NULL
  • update_user — varchar(20) — NOT NULL
  • update_datetime — datetime — NOT NULL
  • user_status — varchar(20) — NOT NULL
  • user_authority — bit — NOT NULL