-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathagar.sch
97 lines (86 loc) · 2.05 KB
/
agar.sch
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
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
TABLE_(MAKER)
INT_ (ID) PRIMARY_KEY AUTO_INCREMENT
STRING_ (MAKER_NAME, 100) INDEX
END_TABLE
TABLE_(GAME)
INT (ID) PRIMARY_KEY AUTO_INCREMENT
INT_ (MAKER_ID)
STRING_ (GAME_NAME, 200) INDEX
END_TABLE
TABLE_(PCB_TYPE)
INT (ID) PRIMARY_KEY AUTO_INCREMENT
STRING_ (LABEL, 200) INDEX
END_TABLE
TABLE_(PCB_STATE)
INT (ID) PRIMARY_KEY AUTO_INCREMENT
STRING (LABEL, 200) INDEX
INT_ (INK)
INT_ (PAPER)
END_TABLE
TABLE_(PCB_FAULT)
INT (ID) PRIMARY_KEY AUTO_INCREMENT
STRING (LABEL, 200) INDEX
END_TABLE
TABLE_(PCB)
INT (ID) PRIMARY_KEY AUTO_INCREMENT
INT_ (GAME_ID)
INT_ (PCB_TYPE_ID)
INT_ (PCB_STATE_ID)
STRING_ (PCB_FAULT_OPTION,20)
STRING_ (TAG, 50) INDEX
INT_ (LOCATION_ID)
INT_ (ORIGIN_ID)
DATE_ (LAST_TEST_DATE) INDEX
STRING_ (INITIAL_ANALYSIS, 1000)
STRING_ (INITIAL_PCB_FAULT_OPTION, 20)
STRING_ (ROM_NAME_DEPR, 20)
STRING_ (SECTION_DEPR, 20)
STRING_ (CRC_32_DEPR, 8)
STRING_ (FLUKE_SIG_DEPR, 4)
INT_ (PINOUT_ID)
STRING_ (PCB_ORIGIN_FAULT_OPTION,20)
STRING_ (PCB_VERSION,20)
BOOL_ (ACTIONS_FIXED)
END_TABLE
TABLE_(PCB_ACTION)
INT (ID) PRIMARY_KEY AUTO_INCREMENT
INT_ (PCB_ID)
INT_ (PARENT_ID)
TIME_ (ACTION_DATE) INDEX
STRING_ (COMMENTARY, 1000) INDEX
BOOL_ (FINISHED)
INT_ (ACTION_TYPE) INDEX
END_TABLE
TABLE_(LOCATION)
INT (ID) PRIMARY_KEY AUTO_INCREMENT
STRING (LABEL, 200) INDEX
END_TABLE
TABLE_(ORIGIN)
INT (ID) PRIMARY_KEY AUTO_INCREMENT
STRING_ (NAME, 200) INDEX
STRING (ORIGIN, 200) INDEX
STRING (COMMENTARY, 1000) INDEX
END_TABLE
TABLE_(PINOUT)
INT (ID) PRIMARY_KEY AUTO_INCREMENT
STRING (LABEL, 20) INDEX
STRING_ (PIN_SIZE, 5)
STRING_ (DETAIL, 1000)
END_TABLE
TABLE_(PICTURE)
INT (ID) PRIMARY_KEY AUTO_INCREMENT
STRING (LABEL, 50) INDEX
BLOB_ (DATA)
BLOB_ (PREVIEW_DATA)
INT (PCB_ID)
END_TABLE
TABLE_(FLUKE)
INT (ID) PRIMARY_KEY AUTO_INCREMENT
STRING_ (ROM_NAME, 20)
STRING_ (SECTION, 20)
STRING_ (CRC_32, 8)
STRING_ (FLUKE_SIG, 4)
INT (PCB_ID)
STRING (ORIGIN, 40)
STRING_ (RANGE, 40)
END_TABLE