-
Notifications
You must be signed in to change notification settings - Fork 0
/
tables sql.txt
83 lines (71 loc) · 1.42 KB
/
tables sql.txt
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
create table company
(
cid number primary key,
cname varchar(30),
curl varchar(30),
cdescription varchar(500),
cphone varchar(30)
);
create table interview
(
iid number primary key,
ititle varchar(100),
idescription varchar(500),
ipaypackage varchar(20),
cid number references company(cid)
);
create table subject
(
sid number primary key,
sname varchar(30)
);
create table scaling
(
scid number primary key,
sid number references subject(sid),
iid number references interview(iid),
scale number
);
create table topic
(
tid number primary key,
tname varchar(30),
trank number,
sid number references subject(sid)
);
create table question
(
qid number primary key,
qtext varchar(500),
qca number,
qrank number,
tid number references topic(tid)
);
create table qoption
(
qoid number primary key,
qoption varchar(500),
qid number references question(qid)
);
create table sys_user
(
suid number primary key,
suname varchar(50),
suemail varchar(50) unique not null,
suphone varchar(20) unique not null
);
create table usr_login
(
suid number primary key references sys_user(suid),
loginid varchar(30) unique not null,
loginpass varchar(30)
);
-------------------------------
select * from
(
select your_columns, row_number()
over (order by something unique) rn
from your_tables
)
where rn between :n and :m
order by rn;