Object Type	Table
Datasource	IPMA
Database	publications

Columns

Name	Datatype	Null

code	char(19)	No

journal	varchar(64)	No

year	int	No

month	int	Yes

volume	char(8)	No

page	char(8)	No

title	char(255)	No

ads	int	Yes

ref	int	No

proc_title	char(255)	Yes

editors	char(64)	Yes

Table Usage (MB)

Distribution of Table Space

Data	0.39	Data	82.50 %
Indexes	0.05	Indexes	10.42 %
Unused	0.03	Unused	7.08 %
Total	0.47	Number of Rows	1138

Dependencies

Referencing Objects

Object Name Object Type

dbo.add_publication PROCEDURE

dbo.delete_publication PROCEDURE

dbo.info.info_ux INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.info 
(
    code       char(19)    NOT NULL,
    journal    varchar(64) NOT NULL,
    year       int         NOT NULL,
    month      int         NULL,
    volume     char(8)     NOT NULL,
    page       char(8)     NOT NULL,
    title      char(255)   NOT NULL,
    ads        int         NULL,
    ref        int         DEFAULT 0 NOT NULL,
    proc_title char(255)   NULL,
    editors    char(64)    NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.add_publication	PROCEDURE
dbo.delete_publication	PROCEDURE
dbo.info.info_ux	INDEX