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