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