Scribd
Upload
21 views4 pages

Data Dictionary

Uploaded by

vikramaraiims
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
21 views4 pages

Data Dictionary

Uploaded by

vikramaraiims
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Attribute Name Data Type Description Constraints

Unique identifier for Primary Key, UUID


AdminID String
each user generated
Not Null, Max 50
firstName String Admins’s first name
chars
Not Null, Max 50
lastName String Admin's last name
chars
Unique, Not Null,
email String Admin’s email address
Email format
Encrypted password
Not Null, Min 8
password String for user
chars
authentication
Attribute Name Data Type Description Constraints
Unique identifier for Primary Key, UUID
postID String
each post generated
The ID of the user
userID String who created the Foreign Key (User)
post
Text or image Not Null, Max
content String
content of the post length varies
Attribute Name Data Type Description Constraints
Unique identifier for
commentID String Primary Key
each comment
The ID of the post
postID String the comment Foreign Key (Post)
belongs to
Text content of the Not Null, Max
content String
comment length varies
Attribute
Data Type Description Constraints
Name
The ID of the
userID String user sending the Foreign Key (User)
request
The ID of the
friendID String user receiving Foreign Key (User)
the request

You might also like