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 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110
|
/*==============================================================*/
/* Table: document */
/*==============================================================*/
create table document (
id_doc bigint identity(1,1),
content ntext not null,
link ntext not null,
icon nvarchar(77) not null,
size nvarchar(55) not null,
date nvarchar(50) not null,
creation nvarchar(50) not null,
modification nvarchar(50) not null,
subject ntext not null,
assos ntext not null,
constraint PK_DOCUMENT primary key (id_doc)
)
go
/*==============================================================*/
/* Table: picture */
/*==============================================================*/
create table picture (
id_pic bigint identity(1,1),
id_site bigint null,
height numeric not null,
width numeric not null,
link_pic ntext not null,
content image not null,
icon nvarchar(30) not null,
constraint PK_PICTURE primary key (id_pic)
)
go
/*==============================================================*/
/* Table: main */
/*==============================================================*/
create table main (
id bigint identity(1,1),
id_site bigint null,
id_pic bigint null,
words ntext not null,
meta_title nvarchar(3) not null,
meta_description nvarchar(3) not null,
meta_keywords nvarchar(3) not null,
occurency nvarchar(50) not null,
percentage nvarchar(50) not null,
doc_type nchar(3) not null,
meta nvarchar(3) not null,
constraint PK_main primary key (id)
)
go
/*==============================================================*/
/* Table: maindoc */
/*==============================================================*/
create table maindoc (
id bigint identity(1,1),
id_doc bigint null,
words ntext not null,
meta_title nvarchar(3) not null,
meta_description character(3) not null,
meta_keywords nvarchar(3) not null,
occurency nvarchar(50) not null,
percentage nvarchar(50) not null,
type nvarchar(3) not null,
meta nvarchar(3) not null,
constraint PK_mainDOC primary key (id)
)
go
/*==============================================================*/
/* Table: web */
/*==============================================================*/
create table web (
id_site bigint identity(1,1),
link ntext not null,
content ntext not null,
description ntext not null,
title ntext not null,
language ntext not null,
country ntext not null,
size nvarchar(30) not null,
date nvarchar(60) not null,
category nvarchar(60) not null,
keywords ntext not null,
constraint PK_WEB primary key (id_site)
)
go
alter table picture
add constraint FK_PICTURE_REFERENCE_WEB foreign key (id_site)
references web (id_site)
go
alter table main
add constraint FK_main_REFERENCE_WEB foreign key (id_site)
references web (id_site)
go
alter table main
add constraint FK_main_REFERENCE_PICTURE foreign key (id_pic)
references picture (id_pic)
go
alter table maindoc
add constraint FK_mainDO_REFERENCE_DOCUMENT foreign key (id_doc)
references document (id_doc)
go |
Partager