POC

Tables (12)

Company (Untitled3)

  • id — Long — Primary key — NOT NULL
  • company_name (Field) — String
  • boss_name (Field2) — String
  • serial_number (Field3) — String
  • company_phone (Field4) — String
  • adress (Field5) — Address

DID (Untitled2)

  • id — Long — Primary key — NOT NULL
  • User (id2) — User — Foreign key → User.id — NOT NULL
  • DID_Code (Field) — String

File (Untitled7)

  • id (Key) — Long — Primary key — NOT NULL
  • examination (Key2) — Examination — Foreign key → examination.id — NOT NULL
  • path (Field) — String

Manager (Untitled10)

  • id — Long — Primary key — NOT NULL
  • examination (Key) — Examination — Foreign key → examination.id — NOT NULL
  • standard_name (Field) — String
  • tester_name (Field2) — String
  • main (Field3) — String
  • managing_date (Field4) — Local_date_time
  • note (Field5) — String

Product (Untitled5)

  • id (Key) — Long — Primary key — NOT NULL
  • product_name (Field)
  • certification (true/false) — boolean
  • new_type (Field3) — Enum
  • sub_model (Field4) — String
  • model_name (Field5) — String
  • model_detail (Field6) — String
  • serial_number (Field2) — String
  • sell_nation (Field7) — String
  • standard (Field8) — String

Require (Untitled8)

  • id (Key) — Long — Primary key — NOT NULL
  • examination (Key2) — Examination — Foreign key → examination.id — NOT NULL
  • content (Field) — String
  • creat_date (Field2) — Local_date_time

Test_form (Untitled11)

  • id — Long — Primary key — NOT NULL
  • examination (Key) — Examination — Foreign key → examination.id — NOT NULL
  • test_type (Field) — String
  • standard_name (Field2) — String
  • content (Field3) — String
  • test_form_files (Field4) — test_form_file
  • create_date (Field5) — Local_date_time
  • writer (Field6) — String

Test_form_file (Untitled12)

  • Key — Primary key — NOT NULL
  • test_form (id) — Test_forn — Foreign key → Test_form.id — NOT NULL
  • path (Field) — String

User (Untitled)

  • id — Long — Primary key — NOT NULL
  • company (Company_PK) — Company — Foreign key → Company.id — NOT NULL
  • user_name (Field) — String
  • password (Field2) — String
  • user_type (제조사/브로커) — ENUM
  • name (Field4) — String
  • user_phone (Field7) — String
  • email (Field8) — String
  • DID (true/false) — boolean
  • part (Field5) — String
  • position (Field6) — String
  • create_date (Field3) — BaseTimeEntity

examination (Untitled4)

  • id (Key) — Long — Primary key — NOT NULL
  • user (id2) — User — Foreign key → User.id — NOT NULL
  • product (Key2) — Long — Foreign key → Product.id — NOT NULL
  • exam_type (Field) — Enum
  • receiver (Field2) — String
  • security (true/false) — boolean
  • company (Field5) — Company
  • factory (Field6) — Company
  • report_language (Field7) — ENUM
  • report_type (Field8) — ENUM
  • agency (Field9) — String
  • sample_name (Field10) — String
  • sample_in_date (Field11) — Local_date_time
  • sample_out_date (Field12) — Local_date_time
  • amount (Field13) — long
  • Warehouse (Field14) — boolean
  • file (List) — file
  • require (Lidy) — file
  • status (Field3) — ENUM
  • test_details (Field4) — test_detail
  • managers (Field15) — Manager
  • test_forms (Field16) — test_form

product_doc (Untitled6)

  • id — Long — Primary key — NOT NULL
  • id (MTO) — Long — Foreign key → Product.id — NOT NULL
  • path (Field) — String

test_detail (Untitled9)

  • id — Long — Primary key — NOT NULL
  • examination (Key) — Examination — Foreign key → examination.id — NOT NULL
  • product_line (Field) — String
  • certification_field (Field2) — String
  • part_name (Field3) — String
  • standard_detail (Field4) — String
  • skill_manager (Field5) — String
  • note (Field6) — String
  • confirm (Field7) — String