webhosting   Cheap Reseller Hosting   links    free hosting by fateback   hosting reseller   100WebSpace offers 100MB Web Space 
Free Links
Free Image Hosting, Web Hosting, Architectural Projects in Bulgaria, Famous People & Celebrity Search, Web Page Hosting

 

NxtGen Logo The Next-Generation Digital Library for the Next-Generation Internet Protocol
:: Project ::
 

:: Programmers ::
 

:: Screenshots ::
  • Guest
  • User
  • Administrator
 

:: Contact ::
 
:: NxtGen Designs ::
Data Design
Logical Database Design
Users Table
Triggers :
Attributes :
Name : Username
Description : This is the username of the user
Program Variable : username
Column Name : username
Data Type : varchar(10)
Code Format :
Constraints : ND, NN
Name : Password
Description : This is the password of the user
Program Variable : password
Column Name : password
Data Type : varchar(10)
Code Format :
Constraints : NN
Name : E-mail Address
Description : This is the e-mail address of the user
Program Variable : email
Column Name : email
Data Type : varchar(50)
Code Format :
Constraints : ND, NN
Name : First Name
Description : This is the first name of the user
Program Variable : firstname
Column Name : firstname
Data Type : varchar(20)
Code Format :
Constraints : NN
Name : Last Name
Description : This is the surname of the user
Program Variable : lastname
Column Name : lastname
Data Type : varchar(20)
Code Format :
Constraints : ND, NN
Name : Privilege
Description : This is the access level of the user
Program Variable : privilege
Column Name : privilege
Data Type : varchar(10)
Code Format :
Constraints : NN
Name : Membership Date
Description : This is the date the user registered to the system
Program Variable : date
Column Name : date
Data Type : date
Code Format :
Constraints : NN
Name : Last Login Date
Description : This is the date the user logged to the system
Program Variable : lastlogin
Column Name : lastlogin
Data Type : date
Code Format :
Constraints : NN
Name : User Number
Description : This is the number of the user
Program Variable : usernumber
Column Name : usernumber
Data Type : bigserial
Code Format :
Constraints : PK
Metadata Table
Triggers :
Attributes :
Name : Filename
Description : This is the filename of the uploaded file
Program Variable : filename
Column Name : filename
Data Type : text
Code Format :
Constraints : NN
Name : Title
Description : This is the title of the file
Program Variable : title
Column Name : title
Data Type : varchar(100)
Code Format :
Constraints : NN
Name : Description
Description : This is the description of the file
Program Variable : description
Column Name : description
Data Type : text
Code Format :
Constraints : NN
Name : Authors
Description : These are the names of the authors of the file
Program Variable : author
Column Name : author
Data Type : varchar(200)
Code Format :
Constraints : NN
Name : Size
Description : This is the size of the file
Program Variable : size
Column Name : size
Data Type : decimal(10)
Code Format :
Constraints : NN
Name : Format
Description : This is the MIME type of the file
Program Variable : format
Column Name : format
Data Type : varchar(100)
Code Format :
Constraints : NN
Name : Creation Date
Description : This is the date the file was uploaded
Program Variable : date
Column Name : date
Data Type : date
Code Format :
Constraints : NN
Name : Metanumber
Description : This is the number of the file
Program Variable : metanumber
Column Name : metanumber
Data Type : bigint
Code Format :
Constraints : PK
Groups Table
Triggers :
Attributes :
Name : Group Name
Description : This is the name of the group or category
Program Variable : groupname
Column Name : groupname
Data Type : varchar(100)
Code Format :
Constraints : ND, NN
Name : Group Number
Description : This is the number of the group or category
Program Variable : groupnumber
Column Name : groupnumber
Data Type : bigserial
Code Format :
Constraints : PK
Affiliations Table
Triggers :
Attributes :
Name : User ID
Description : This is the number of the user
Program Variable : userid
Column Name : userid
Data Type : bigint
Code Format :
Constraints : FK User Number, Users
Name : Group ID
Description : This is the number of the group where the user joined
Program Variable : groupid
Column Name : groupid
Data Type : bigint
Code Format :
Constraints : FK Group Number Groups
Junctions Table
Triggers :
Attributes :
Name : User ID
Description : This is the number of the user
Program Variable : userid
Column Name : userid
Data Type : bigint
Code Format :
Constraints : FK User Number, Users
Name : Group ID
Description : This is the number of the group where the file is shared
Program Variable : groupid
Column Name : groupid
Data Type : bigint
Code Format :
Constraints : FK Group Number Groups
Name : Meta ID
Description : This is the number of the uploaded file
Program Variable : metaid
Column Name : metaid
Data Type : bigint
Code Format :
Constraints : FK Metanumber, Metadata
Name : File ID
Description : This is the number of the uploaded file
Program Variable : fileid
Column Name : fileid
Data Type : bigint
Code Format :
Constraints : FK Upload ID, Uploads
Uploads Table
Triggers :
Attributes :
Name : Filename
Description : This is the filename of the uploaded file
Program Variable : filename
Column Name : filename
Data Type : text
Code Format :
Constraints : NN
Name : Upload ID
Description : This is the number of the file
Program Variable : uploadid
Column Name : uploadid
Data Type : serial
Code Format :
Constraints : PK
Name : Binary File
Description : This is the uploaded file
Program Variable : binaryfile
Column Name : binaryfile
Data Type : bytea
Code Format :
Constraints : NN
Architectural Design
NxtGen Design
 

NxtGen Core ®    Copyright © NxtGen ®    All rights reserved 2003-2004

Valid HTML 4.01! Valid CSS!