| Tables |
|
GIROS_FLETES
| Tables |
|
GIROS_FLETES
Description
(There is no description for table GIROS_FLETES)
Fields
PK | FK | Field | Domain | Type | NN | Default | Description |
|---|---|---|---|---|---|---|---|
|
|
CODOPERADOR |
|
CHAR(15) |
|
|
|
|
|
TIPO |
|
CHAR(10) |
|
|
|
|
|
LIMITE_INFERIOR |
|
NUMERIC(17,4) |
|
0 |
|
|
|
LIMITE_SUPERIOR |
|
NUMERIC(17,4) |
|
0 |
|
|
|
FLETE |
|
NUMERIC(17,4) |
|
0 |
|
|
|
PORCENTAJE |
|
NUMERIC(17,4) |
|
0 |
|
|
|
COMISION |
|
NUMERIC(17,4) |
|
0 |
|
Triggers
(There are no triggers for table GIROS_FLETES)
Indices
Index | Fields | Active | Unique | Order |
|---|---|---|---|---|
CODOPERADOR |
|
|
ASC |
|
CODOPERADOR, TIPO, LIMITE_INFERIOR |
|
|
ASC |
References
Table | Foreign Key | Fields | FK Field | Delete Rule | Update Rule |
|---|---|---|---|---|---|
CODOPERADOR |
CODIGO |
NO ACTION |
CASCADE |
Referenced By
(There are no tables referenced by table GIROS_FLETES)
Definition
CREATE TABLE GIROS_FLETES (
CODOPERADOR CHAR(15) NOT NULL,
TIPO CHAR(10) NOT NULL,
LIMITE_INFERIOR NUMERIC(17,4) DEFAULT 0 NOT NULL,
LIMITE_SUPERIOR NUMERIC(17,4) DEFAULT 0,
FLETE NUMERIC(17,4) DEFAULT 0,
PORCENTAJE NUMERIC(17,4) DEFAULT 0,
COMISION NUMERIC(17,4) DEFAULT 0
);
ALTER TABLE GIROS_FLETES ADD CONSTRAINT PK_GIROS_FLETES PRIMARY KEY (CODOPERADOR, TIPO, LIMITE_INFERIOR);
ALTER TABLE GIROS_FLETES ADD CONSTRAINT FK_GIROS_FLETES_1 FOREIGN KEY (CODOPERADOR) REFERENCES OPERADORES (CODIGO) ON UPDATE CASCADE;
|
|
