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