Scribd
Upload
6 views7 pages

Data Dictionary

The document is a data dictionary outlining the structure of various entities related to an organization, such as Organization, Designation, Users, and Transactions. Each entity includes attributes like IDs, names, contact information, and permissions for actions like view, add, edit, and delete. It serves as a reference for understanding the database schema and relationships between different data elements.

Uploaded by

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

Data Dictionary

The document is a data dictionary outlining the structure of various entities related to an organization, such as Organization, Designation, Users, and Transactions. Each entity includes attributes like IDs, names, contact information, and permissions for actions like view, add, edit, and delete. It serves as a reference for understanding the database schema and relationships between different data elements.

Uploaded by

zampadiyaajay2002
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 7

Data Dictionary

Organization
Name Organization

OrganizationId int
OrgUId int
Name varchar(100)
StartDate datetime
EndDate datetime
ContactNo varchar(20)

Designation
Designatio
Name n

DesignationId int
OrganizationId fk
DesignationNa varchar(10
me 0)
eDesignation int
SerialNo int
eStatus int

DesignationAuthority
DesignationAuthori
Name ty

DesignationAuthority
Id int
DesignationId fk
eAuthority int
IsAllowView boole
IsAllowAdd boole
IsAllowEdit boole
IsAllowDelete boole

Users
Name Users

UsersId int
OrganizationI
d fk
Name varchar(100)
MobileNo varchar(20)
Email varchar(500)
UserAuthority
UserAuthorit
Name y

UserAuthorityI
d int
UsersId fk
eAuthority int
IsAllowView boole
IsAllowAdd boole
IsAllowEdit boole
IsAllowDelete boole

Login
Name Login

LoginId int
UsersId fk
UserNam varchar(10
e 0)
varchar(10
Password 0)

PasswordHistory
PasswordHisto
Name ry

PasswordHistory
Id int
LoginId fk
Password varchar(100)
PwdSalt varchar(100)
CreateDate datetime

ProcessType
ProcessTyp
Name e

ProcessTypeI
d int
OrganizationI
d fk
varchar(100
Name )
SerialNo int

CreatedUsers int
CreatedTime datetime
UpdatedUser
s int
UpdatedTime datetime
DeletedUsers int
DeletedTime datetime
eStatus int
RateTemplate
RateTemplat
Name e

RateTemplateI
d int
OrganizationId fk
ProcessTypeId fk
Rate decimal
SerialNo int

CreatedUsers int
CreatedTime datetime
UpdatedUsers int
UpdatedTime datetime
DeletedUsers int
DeletedTime datetime
eStatus int

Employee
Name Employee

EmployeeId int
OrganizationI
d fk
Name varchar(100)
EmployeeNo int
MobileNo varchar(20)

CreatedUsers int
CreatedTime datetime
UpdatedUsers int
UpdatedTime datetime
DeletedUsers int
DeletedTime datetime
eStatus int

EmployeeType
EmployeeTyp
Name e

EmployeeTypeI
d int
EmployeeId fk
ProcessTypeId fk
DailyWork
DailyWor
Name k

DailyWorkId int
OrganizationI
d fk
Date datetime

CreatedUsers int
CreatedTime datetime
UpdatedUser
s int
UpdatedTime datetime
DeletedUsers int
DeletedTime datetime
eStatus int

DailyWorkDetail
DailyWorkDeta
Name il

DailyWorkDetailI
d int
DailyWorkId fk
EmployeeId fk
ProcessTypeId fk
Diamond int
Rate decimal

Transaction
Transactio
Name n

TransactionId int
OrganizationId fk
EmployeeId fk
Date datetime
Amount decimal
eTransactionTy
pe int

CreatedUsers int
CreatedTime datetime
UpdatedUsers int
UpdatedTime datetime
DeletedUsers int
DeletedTime datetime
eStatus int

You might also like