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