-
Notifications
You must be signed in to change notification settings - Fork 0
/
script_bd.sql
32 lines (31 loc) · 1.25 KB
/
script_bd.sql
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
CREATE TABLE SETORES (
CODIGO VARCHAR(10) NOT NULL,
SETOR VARCHAR(100) NOT NULL,
SUBSETOR VARCHAR(100) NOT NULL,
SEGMENTO VARCHAR(100) NOT NULL,
CONSTRAINT CODIGO PRIMARY KEY (CODIGO)
)CREATE TABLE ACOES (
AC_ID INT IDENTITY NOT NULL,
DATA DATETIME NOT NULL,
CODBDI INT NOT NULL,
CODNEG VARCHAR(10) NOT NULL,
TPMERC INT NOT NULL,
NOMRES VARCHAR(50) NOT NULL,
ESPECI VARCHAR(50) NOT NULL,
MODREF VARCHAR(10) NOT NULL,
PREABE DECIMAL(10,2) NOT NULL,
PREMAX DECIMAL(10,2) NOT NULL,
PREMIN DECIMAL(10,2) NOT NULL,
PREMED DECIMAL(10,2) NOT NULL,
PREULT DECIMAL(10,2) NOT NULL,
PREOFC DECIMAL(10,2) NOT NULL,
PREOFV DECIMAL(10,2) NOT NULL,
TOTNEG INT NOT NULL,
QUATOT BIGINT NOT NULL,
VOLTOT DECIMAL(15,2) NOT NULL,
FATCOT INT NOT NULL,
CODISI VARCHAR(50) NOT NULL,
DISMES INT NOT NULL,
CONSTRAINT AC_ID PRIMARY KEY (AC_ID)
)