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