bansock
Tables (12)
answer
- id — int — Primary key — NOT NULL
- question_id — int — Foreign key → question.id — NOT NULL
- title — varchar(255)
- placeholder — varchar(100)
- unit — varchar(100)
- infomation_type — varchar(100)
- infomation_title — varchar(255)
- infomation — varchar(255)
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
application
- id — int — Primary key — NOT NULL
- category — varchar(191)
- part_name — varchar(191)
- viscosity — int — questionId - 6
- discharge_accuracy — int — questionId - 9
- mixing_ratio — int — questionId - 3
- keywords — varchar(191)
- primeCost — int
- userKRW — int
- userUSD — int
- FILLER_SUPPORT — enum('YES', 'NO', 'EVERYTHING')
- HIGH_LOW_PRICE — enum('HIGH_PRICE', 'LOW_PRICE', 'EVERYTHING') — questionId - 16
- SUPPLY_FORM — enum('BARREL_SYRINGE', 'CARTRIDGE', 'TANK', 'CAN_DRUM', 'TANK_OR_CAN_DRUM', 'EXCEPT_TANK_OR_CAN_DRUM', 'EVERYTHING') — questionId - 12
- ONE_COMPONENT_OR_TWO — enum('ONE_COMPONENT', 'TWO_COMPONENT', 'EVERYTHING')
bom
- id — int — Primary key — NOT NULL
- fileInfo — text
- personal — text
- survey — text
- etc — text
- answer — text
- duplicate — tinyint(1)
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
control
- id — int — Primary key — NOT NULL
- category — varchar(191)
- part_name — varchar(191)
- primeCost — int
- userKRW — int
- userUSD — int
cunsulting
- id — int — Primary key — NOT NULL
- company_name — varchar(255) — NOT NULL
- location — varchar(255) — NOT NULL
- pos — varchar(255) — NOT NULL
- part — varchar(255) — NOT NULL
- phone — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- description — varchar(255)
- visitDate — varchar(255)
- expected_attend — varchar(255)
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
discharge
- id — int — Primary key — NOT NULL
- category — varchar(191)
- part_name — varchar(191)
- operation_method — varchar(191)
- viscosity — int — questionId - 6
- specific_gravity — int — questionId - 7
- discharge_accuracy — int — questionId - 9
- median_discharge_amount — double — questionId - 8
- keywords — varchar(191)
- control — varchar(191)
- etc — varchar(191)
- primeCost — int
- supply — varchar(191)
- userKRW — int
- userUSD — int
- AUTOMATION — enum('MANUAL', 'Automated', 'EVERYTHING') — questionId - 14
- CURING_CONDITIONS — enum('WATER_REACTION', 'ANAEROBIC_REACTION', 'ROOM_TEMPERATURE', 'UV_CURING', 'TWO_COMPONENT_CURING', 'HEATED_CURING', 'NOT_CURING', 'EVERYTHING') — questionId - 11
- FILLER_SUPPORT — enum('YES', 'NO', 'EVERYTHING') — questionId - 10
- HOW_TO_USE_IT — enum('LINE_DISPENSING', 'DOT_DISPENSING', 'LINE_DISPENSING_OR_DOT_DISPENSING', 'MOLDING_FILLING_METERING_VALVE', 'UNDERFILLING', 'SEALING', 'CONFORMAL_COATING_SPRAYING_SPRAY_VALVE', 'EVERYTHING') — questionId - 5
- ONE_COMPONENT_OR_TWO — enum('ONE_COMPONENT', 'TWO_COMPONENT', 'EVERYTHING') — questionId - 2
- SUPPLY_FORM — enum('BARREL_SYRINGE', 'CARTRIDGE', 'TANK', 'CAN_DRUM', 'TANK_OR_CAN_DRUM', 'EXCEPT_TANK_OR_CAN_DRUM', 'EVERYTHING') — questionId - 12
- USE_TWO_COMPONENT_CARTRIDGE — enum('YES', 'NO', 'EVERYTHING') — NOT NULL — questionId - 4
- SUPPROT_PASTE — enum('YES', 'NO', 'EVERYTHING') — questionId - 6
etc
- id — int — Primary key — NOT NULL
- category — varchar(191)
- part_name — varchar(191)
- price — int
file
- id — int — Primary key — NOT NULL
- type — int — Foreign key → file_type.id — NOT NULL
- parent — int
- name — varchar(100)
- filename — varchar(100)
- mimetype — varchar(100)
- path — varchar(300)
- size — varchar(100)
- uploaded_at — timestamp
file_type
- id — int — Primary key — NOT NULL
- name — varchar(100)
- created_at — timestamp
question
- id — int — Primary key — NOT NULL
- no — varchar(100) — NOT NULL
- require — varchar(100) — NOT NULL
- title — varchar(255) — NOT NULL
- type — varchar(100) — NOT NULL — 0 - select / 1 - input
- sub — int — 특정 값 입력 시 특정 필드로 이동
- duplicate — tinyint — NOT NULL — 0 - single / 1 - duplicate
- multiple — tinyint — NOT NULL — 0 - disable, 1 - enable
- together — int — NOT NULL — 0 - disable, 동시에 보여줄 id
- infomation_type — varchar(100)
- infomation_title — varchar(255)
- infomation — varchar(255)
- default — varchar(100)
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
robot
- id — int — Primary key — NOT NULL
- category — varchar(191)
- part_name — varchar(191)
- product_size_X — int — questionId - 15
- product_size_Y — int — questionId - 15
- product_size_Z — int
- keywords — varchar(191)
- etc — varchar(191)
- HIGH_LOW_PRICE — enum('HIGH_PRICE', 'LOW_PRICE', 'EVERYTHING') — questionId - 16
- primeCostUSD — int
- userKRW — int
- userUSD — int
supply
- id — int — Primary key — NOT NULL
- category — varchar(191)
- supply_capacity_L — double — questionId - 12
- viscosity — int — questionId - 6
- specific_gravity — int — questionId - 7
- discharge — varchar(191)
- keywords — varchar(191)
- application — varchar(191)
- etc — varchar(191)
- max_discharge_amount — int — questionId - 8
- part_name — varchar(191)
- primeCost — int
- userKRW — int
- userUSD — int
- HIGH_LOW_PRICE — enum('HIGH_PRICE', 'LOW_PRICE', 'EVERYTHING') — questionId - 16
- SUPPLY_FORM — enum('BARREL_SYRINGE', 'CARTRIDGE', 'TANK', 'CAN_DRUM', 'TANK_OR_CAN_DRUM', 'EXCEPT_TANK_OR_CAN_DRUM', 'EVERYTHING') — questionId - 12
- SUPPROT_PASTE — enum('YES', 'NO', 'EVERYTHING') — questionId - 6