27 |
|
|
28 |
CREATE TABLE libstats.elementstats ( |
CREATE TABLE libstats.elementstats ( |
29 |
elementstats_id INT4 DEFAULT nextval('libstats.elementstats_elementstats_id'), |
elementstats_id INT4 DEFAULT nextval('libstats.elementstats_elementstats_id'), |
30 |
page_id INT4 DEFAULT NULL, |
page_id INT4 references page(page_id), |
31 |
element_id INT4 DEFAULT NULL, |
element_id INT4 references element(element_id), |
32 |
resource_id INT4 DEFAULT NULL, |
resource_id INT4 references resource(resource_id), |
33 |
location_id INT4 DEFAULT NULL, |
location_id INT4 references location(location_id), |
34 |
service_id INT4 DEFAULT NULL, |
service_id INT4 references service(service_id), |
35 |
staff_id INT4 DEFAULT NULL, |
staff_id INT4 references staff(staff_id), |
36 |
subject_id INT4 DEFAULT NULL, |
subject_id INT4 references subject(subject_id), |
37 |
visit_date TIMESTAMP DEFAULT NULL, |
visit_date TIMESTAMP DEFAULT NULL, |
38 |
user_ip varchar(15) DEFAULT NULL, |
user_ip varchar(15) DEFAULT NULL, |
39 |
PRIMARY KEY (elementstats_id) |
PRIMARY KEY (elementstats_id) |
62 |
|
|
63 |
CREATE TABLE libstats.pagestats ( |
CREATE TABLE libstats.pagestats ( |
64 |
pagestats_id INT4 DEFAULT nextval('libstats.pagestats_pagestats_id_seq'), |
pagestats_id INT4 DEFAULT nextval('libstats.pagestats_pagestats_id_seq'), |
65 |
page_id INT4 DEFAULT NULL, |
page_id INT4 references page(page_id), |
66 |
visit_date TIMESTAMP DEFAULT NULL, |
visit_date TIMESTAMP DEFAULT NULL, |
67 |
user_ip varchar(15) DEFAULT NULL, |
user_ip varchar(15) DEFAULT NULL, |
68 |
PRIMARY KEY (pagestats_id) |
PRIMARY KEY (pagestats_id) |
133 |
|
|
134 |
CREATE TABLE libstats.substats ( |
CREATE TABLE libstats.substats ( |
135 |
substats_id INT4 DEFAULT nextval('libstats.substats_substats_id_seq'), |
substats_id INT4 DEFAULT nextval('libstats.substats_substats_id_seq'), |
136 |
subject_id INT4 DEFAULT NULL, |
subject_id INT4 references subject(subject_id), |
137 |
visit_date TIMESTAMP DEFAULT NULL, |
visit_date TIMESTAMP DEFAULT NULL, |
138 |
user_ip varchar(15) DEFAULT NULL, |
user_ip varchar(15) DEFAULT NULL, |
139 |
PRIMARY KEY (substats_id) |
PRIMARY KEY (substats_id) |