asdf

Tables (9)

Areas

  • area_number — TINYINT — Primary key — NOT NULL
  • area_name — VARCHAR(40) — NOT NULL

Builders

  • build_number — INTEGER — Primary key — NOT NULL
  • build_name — VARCHAR(20) — NOT NULL
  • warning_stack — INTEGER — NOT NULL
  • build_contact — CHAR(13) — NOT NULL

BuildingSets

  • building_set_number — TINYINT — Primary key — NOT NULL
  • building_set_name — VARCHAR(16) — NOT NULL
  • area_number — TINYINT — NOT NULL
  • build_number — INTEGER — NOT NULL

Cements

  • cement — VARCHAR(12) — Primary key — NOT NULL
  • cement_type — CHAR(20) — NOT NULL

Curings

  • measure_date — date — Primary key — NOT NULL
  • struct_id — CHAR(11) — Primary key — NOT NULL
  • concrete_temperature — SMALLINT — NOT NULL
  • cover_installed — BOOLEAN — NOT NULL
  • tent_installed — BOOLEAN — NOT NULL
  • heating_device_installed — BOOLEAN — NOT NULL
  • measured_strengrth — SMALLINT — NOT NULL

ExternalEnvironmentVariables

  • measure_date — date — Primary key — NOT NULL
  • area_number — TINYINT — Primary key — NOT NULL
  • measurement_date — date — NOT NULL
  • humidty — TINYINT — NOT NULL
  • sunshine — TINYINT — NOT NULL
  • temperature — TINYINT — NOT NULL
  • wind_velocity — TINYINT — NOT NULL
  • warning — CHAR(4) — NOT NULL
  • daily_maximum_temperature — TINYINT — NOT NULL
  • daily_minimum_temperature — TINYINT — NOT NULL

Managers

  • manager_number — CHAR(10) — Primary key — NOT NULL
  • builder_number — INTEGER — NOT NULL
  • manager_name — VARCHAR(10) — NOT NULL
  • manager_contact — CHAR(13) — NOT NULL

Pourings

  • sturct_id — CHAR(11) — Primary key — NOT NULL
  • cement2 — VARCHAR(12) — Foreign key → Cements.cement — NOT NULL
  • pouring_date — date — NOT NULL
  • cement — VARCHAR(12) — NOT NULL
  • curing_method — VARCHAR(6) — NOT NULL
  • unit_water_measurement_method — VARCHAR(14) — NOT NULL
  • unit_water — SMALLINT — NOT NULL
  • design_strength — SMALLINT — NOT NULL
  • mixture_strength — SMALLINT — NOT NULL

Structures

  • struct_id — CHAR(10) — Primary key — NOT NULL
  • build_number — INTEGER — NOT NULL
  • manager_number — CHAR(10) — NOT NULL
  • building_set_number — INTEGER — NOT NULL
  • area_number — TINYINT — NOT NULL
  • structure_type — VARCHAR(10) — NOT NULL
  • building_number — TINYINT — NOT NULL
  • floor — TINYINT — NOT NULL
  • room_number — TINYINT — NOT NULL