Data structures extracted from two elevator enterprise data sets
| Data source | Table name | Attributes | |
|---|---|---|---|
| Design depart. | elevator_info | a; b; c; d | |
| client_info | e; f; g; h | ||
| order_info | i; a′; e'; j | ||
| Maintenance depart. | elevator_info | k; l; m; n | |
| record_info | o; p; q; r | ||
| component_info | k′; o'; s; t | ||
| (1) a: Elevator no | b: Elevator model | c: Elevator specifications | d: Elevator interior |
| (2) e: Client no | f: Client name | g: Client address | h: Client contact |
| (3) i: Registration no | a′: Elevator no | e′: Client no | j: Elevator price |
| (4) k: Registration no | l: Floor number | m: Building name | n: Elevator address |
| (5) o: Maintenance id | p: Elevator fault | q: Repair time | r: Maintenance time |
| (6) k': Registration no | o′: Maintenance id | s: Maintenance parts | t: Maintenance price |
| Data source | Table name | Attributes | |
|---|---|---|---|
| Design depart. | elevator_info | a; b; c; d | |
| client_info | e; f; g; h | ||
| order_info | i; a′; e'; j | ||
| Maintenance depart. | elevator_info | k; l; m; n | |
| record_info | o; p; q; r | ||
| component_info | k′; o'; s; t | ||
| (1) a: Elevator no | b: Elevator model | c: Elevator specifications | d: Elevator interior |
| (2) e: Client no | f: Client name | g: Client address | h: Client contact |
| (3) i: Registration no | a′: Elevator no | e′: Client no | j: Elevator price |
| (4) k: Registration no | l: Floor number | m: Building name | n: Elevator address |
| (5) o: Maintenance id | p: Elevator fault | q: Repair time | r: Maintenance time |
| (6) k': Registration no | o′: Maintenance id | s: Maintenance parts | t: Maintenance price |
Sharing content requires targeting cookies to be enabled. Please update your cookie preferences to use this feature.