-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathscripts.sql
More file actions
42 lines (38 loc) · 764 Bytes
/
Copy pathscripts.sql
File metadata and controls
42 lines (38 loc) · 764 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
create table settings
(
name nvarchar(4000),
value ntext,
constraint settings_pk primary key(name)
)
create table cars
(
id int identity,
description ntext,
constraint cars_pk primary key(id)
)
create table inventories
(
id int identity,
code nvarchar(4000),
description ntext,
price money,
constraint inventories_pk primary key(id)
)
create table orders
(
id int identity,
car_id int,
order_date datetime,
constraint orders_pk primary key(id)
)
create table order_inventories
(
id int identity,
order_id int,
sequence_id int,
inventory_id int,
inventory_quantity int,
inventory_price money,
inventory_date datetime,
constraint order_items_pk primary key(id)
)