Tables Previous topic Chapter index Next topic

MONEDAS

 

Description

(There is no description for table MONEDAS)

 

Fields

PK

FK

Field

Domain

Type

NN

Default

Description

 

CODIGO

 

CHAR(5)

 

 

 

 

NOMBRE

 

CHAR(80)

 

 

 

 

SIGNO

 

CHAR(5)

 

 

 

 

VALORENTERO

 

CHAR(20)

 

 

 

 

VALORDECIMAL

 

CHAR(20)

 

 

 

Triggers

(There are no triggers for table MONEDAS)

 

Indices

Index

Fields

Active

Unique

Order

PK_MONEDAS

CODIGO

ASC

 

References

(There are no references for table MONEDAS)

 

Referenced By

Table

Foreign Key

Fields

FK Field

Delete Rule

Update Rule

FACTORING

FK_FACTORING_3

CODMONEDA

CODIGO

NO ACTION

CASCADE

MONEDASVALOR

FK_MONEDASVALOR_1

CODMONEDA

CODIGO

NO ACTION

CASCADE

 

Definition

CREATE TABLE MONEDAS (
    CODIGO        CHAR(5) NOT NULL,
    NOMBRE        CHAR(80) NOT NULL,
    SIGNO         CHAR(5),
    VALORENTERO   CHAR(20),
    VALORDECIMAL  CHAR(20)
);


ALTER TABLE MONEDAS ADD CONSTRAINT PK_MONEDAS PRIMARY KEY (CODIGO);

 

     Previous topic Chapter index Next topic