Universal Server: Новые типы данных
| create table customer( |  | |
| ЖЖЖ |
cname caddress start_year location | varchar(30), varchar(40), int, point); |
| create table order( | ||
|
orderID cname amount date PO_fax order_notes materials ship_location |
int, varchar(30), money, date, image, doc, setof(part_type), point); |
Pозничная торговля
| create table facility( | | |
| ЖЖЖ |
fname faddress location |
varchar(30), addr_type, fac_loc_t); |
| create table route( | ||
|
route description route_map route_notes route_pts |
varchar(20), varchar(100), GeoMap, doc, setof(fac_loc_t)); |
Логистика/Транспорт
| create table facility( | | |
| ЖЖЖ |
fname faddress location |
varchar(30), addr_type, fac_loc_t); |
| create table component( | ||
|
comp_id description fname maint_sched comp_loc comp_notes schematic |
comp_id_t, varchar(100), varchar(30), TimeSeries, point, doc, largeObject); |
Промышленность