erd

Tables (3)

BusinessMember

  • Key_id (key_id) — Long — Primary key — NOT NULL
  • business_number (b_number) — Integer
  • license — String

Fastener

  • fastener_id (id) — Long — Primary key — NOT NULL
  • materials_height (height) — double
  • fasten_deviation (fd) — double
  • pressure_value (pv) — double
  • torque_val (tv) — double
  • true_false (t_f) — Integer
  • Key_id (key_id) — Long — Foreign key → BusinessMember.Key_id — NOT NULL

Posture

  • posture_id (id) — Long — Primary key — NOT NULL
  • top_displacement (td) — double
  • bottom_displacement (bd) — double
  • top_pressure (tp) — double
  • bottom_pressure (bp) — double
  • ture_false (t_f) — Integer
  • Key_id (key_id) — Long — Foreign key → BusinessMember.Key_id — NOT NULL