TestERD
Tables (6)
AS (as)
- AS_No (as_no) — BigInt — Primary key — NOT NULL
- Machine_Name (machine_name) — varchar(50) — NOT NULL
- AS_Date (as_date) — datetime — NOT NULL
- AS_Engineer (as_engineer) — varchar(50) — NOT NULL
- AS_Detail (as_detail) — text
- AS_Type_No (as_type_no) — int — NOT NULL
- AS_Payment_Type (as_payment_type) — bit(1) — NOT NULL
- AS_Use_Parts (as_use_parts) — varchar(255)
- AS_Status (as_status) — varchar(20) — NOT NULL
- Deleted_At (deleted_at) — bit(1) — NOT NULL
- Serial_No (serial_no) — varchar(50) — Foreign key → Machine.Serial_No — NOT NULL
AS_Type (as_type)
- AS_Type_Index (as_type_index) — int — Primary key — NOT NULL
- AS_No (as_no) — BigInt — Foreign key → AS.AS_No — NOT NULL
- AS_Type_ID (as_type_id) — int — Foreign key → AS_Type_Name.AS_Type_ID — NOT NULL
AS_Type_Name (as_type_name)
- AS_Type_ID (as_type_id) — int — Primary key — NOT NULL
- AS_Type_Name (as_type_name) — varchar(50) — NOT NULL
Distributor (distributor)
- Distributor_Code (distributor_code) — int — Primary key — NOT NULL
- Distributor_Name (distributor_name) — varchar(50) — NOT NULL
Login (login)
- Login_ID (login_id) — varchar(50) — Primary key — NOT NULL
- Login_PW (login_pw) — varchar(50) — NOT NULL
- User_Name (user_name) — varchar(50) — NOT NULL
- Login_Level (login_level) — int — NOT NULL
- Phone_Number (phone_number) — varchar(50) — NOT NULL
- Deleted_At (deleted_at) — bit(1) — NOT NULL
- Distributor_Code (distributor_code) — int — Foreign key → Distributor.Distributor_Code — NOT NULL
Machine (machine)
- Serial_No (serial_no) — varchar(50) — Primary key — NOT NULL
- QR_Code_URL_Image (qr_code_url_image) — text — NOT NULL
- Machine_Name (machine_name) — varchar(50) — NOT NULL
- Shipment_Date (shipment_date) — datetime — NOT NULL
- Machine_Picture (machine_picture) — text — NOT NULL
- Machine_Test_Document (machine_test_document) — text — NOT NULL
- Warehousing_Date (warehousing_date) — datetime
- Customer_Build_Date (customer_build_date) — datetime
- Customer_Type (customer_type) — varchar(50)
- Where_To_Buy (where_to_buy) — varchar(50) — NOT NULL
- Deleted_At (deleted_at) — bit(1) — NOT NULL
- Distributor_Code (distributor_code) — int — Foreign key → Distributor.Distributor_Code — NOT NULL