mcSLD/mc.sql at master · kfqkfy/mcSLD · GitHub

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
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
create table b_service_util(
id serial primary key,
name varchar(50),
description varchar(50),
monitor_status char(2),
version varchar(20),
ip varchar(20),
port varchar(10),
created_by varchar(50),
created_on varchar(50),
last_changed_by varchar(50),
last_changed_on varchar(50)
)


create table b_app_cluster(
id serial primary key,
name varchar(50),
description varchar(50),
monitor_status char(2),
ip varchar(20),
version varchar(20),
port varchar(10),
su_id integer not null,
created_by varchar(50),
created_on varchar(50),
last_changed_by varchar(50),
last_changed_on varchar(50),
FOREIGN KEY (su_id) REFERENCES b_service_util(id)
)

drop table b_app_cluster


create table b_app_instance(
id serial primary key,
name varchar(50),
description varchar(50),
monitor_status char(2),
ip varchar(20),
version varchar(20),
port varchar(10),
sc_id integer not null,
created_by varchar(50),
created_on varchar(50),
last_changed_by varchar(50),
last_changed_on varchar(50),
FOREIGN KEY (sc_id) REFERENCES b_app_cluster(id)
)

drop table b_app_instance

create table b_db_cluster(
id serial primary key,
name varchar(50),
description varchar(50),
monitor_status char(2),
ip varchar(20),
port varchar(10),
db_type varchar(10),
db_version varchar(10),
connection_user_name varchar(20),
connection_user_password varchar(20),
su_id integer not null,
created_by varchar(50),
created_on varchar(50),
last_changed_by varchar(50),
last_changed_on varchar(50),
FOREIGN KEY (su_id) REFERENCES b_service_util(id)
)

drop table b_db_cluster

create table b_db_instance (
id serial primary key,
name varchar(50),
description varchar(50),
monitor_status char(2),
ip varchar(20),
db_type varchar(10),
db_version varchar(10),
connection_user_name varchar(20),
connection_user_password varchar(20),
dbc_id integer not null,
created_by varchar(50),
created_on varchar(50),
last_changed_by varchar(50),
last_changed_on varchar(50),
FOREIGN KEY (dbc_id) REFERENCES b_db_cluster(id)
)

drop table b_db_instance

create table b_customer(
id serial primary key,
name varchar(50)
)

create table b_tenant(
id serial primary key,
name varchar(50),
description varchar(50),
monitor_status char(2),
version varchar(10),
lc_status char(2),
usage varchar(10),
connection_user_password varchar(20),
dbi_id integer not null,
cid integer not null,
created_by varchar(50),
created_on varchar(50),
last_changed_by varchar(50),
last_changed_on varchar(50),
FOREIGN KEY (dbi_id) REFERENCES b_db_instance(id),
FOREIGN KEY (cid) REFERENCES b_customer(id)
)