ABCDEFGHIJKLMNOPQRSTUVWXY
1
2
3
INDEXTable NameDescription
4
1Part
5
2CustomerHolds customer name, address (for location table), number of orders, amount spent, average order fufilment time and other key data about factory customers
6
3OrderHolds the customer, order ID, time ordered, and what they want. one line item per product ordered, with each refering to the order.
7
4LocationThis table holds a location. A location is a place in the world, defined as a x,y offset from a lattitude longitude. +x is east. -Y is south. z+ is up in altitude z- is down in altitude. The latitude longitudes i think will be commonly derived from google maps interpretation of an address in most cases.
8
5Production MachineMachines used to produce goods.
9
6Assemblycontains the directory for assembly operation files
10
7Assembly operation types
11
8Shipped goods
12
9Recieved goods
13
10FactoryIdentificaion information for a factory that can produce goods. might be a view.
14
11CAD files
15
12Tools
16
13Inventory and Localizationwhere and qty of parts and tools. Includes stuff that is inbound to the factory, in the factory, and goods shipped to a customer.
17
14Finished ProductsA part is offically called a Finished product when it is in the final form of the orgin order that caused it to be made or picked from stock.
18
15Unfinished productsKeeps track of products that are not finished yet. there is a row for each item in an order. children are all the parts on their way to make the final product
19
16Unfinished product partsChild table of unfinished products. these are all the parts that will go into the final product. at inception of an order, these are generated in the DB as new data or are existing stock in inventory and localization that are picked
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100