Schema documentation for DemoBackend::Schema

Contact

Columns

	Name	Type	Autoinc	Nullable	Default	Unique	Indexed
pk	id	uuid(16)			uuid_generate_v4()	primary
fk	user_id	uuid(16)
	contact_name	varchar(50)
	contact_number	varchar(100)
	contact_address	varchar(255)		yes
	contact_state	varchar(100)		yes
	contact_city	varchar(100)		yes
	contact_email	varchar(100)		yes
	generated	integer		yes	date_part('epoch'::text, now())
	contact_notes	varchar(255)		yes
	contact_status	varchar(30)		yes	'ACTIVE'

Relationships

Name	Class	Relation type	Cascade on	Condition
contact_pics	ContactPic	has_many		id => contact_pics.contact_id
user	User	belongs_to		user_id => user.user_id

ContactPic

Columns

	Name	Type	Autoinc	Nullable	Default	Unique	Indexed
pk	id	uuid(16)			uuid_generate_v4()	primary
fk	contact_id	uuid(16)
	profile_pic	text		yes

Relationships

Name	Class	Relation type	Cascade on	Condition
contact	Contact	belongs_to		contact_id => contact.id

Permission

Columns

	Name	Type	Autoinc	Nullable	Default	Unique	Indexed
pk	permission_id	varchar(20)				primary
	permission_desc	varchar(50)				permissions_permission_desc_key

Relationships

Name	Class	Relation type	Cascade on	Condition
role_permissions	RolePermission	has_many		permission_id => role_permissions.permission_id

Role

Columns

	Name	Type	Autoinc	Nullable	Default	Unique	Indexed
pk	role_id	varchar(20)				primary
	role_desc	varchar(50)				roles_role_desc_key

Relationships

Name	Class	Relation type	Cascade on	Condition
role_permissions	RolePermission	has_many		role_id => role_permissions.role_id
user_roles	UserRole	has_many		role_id => user_roles.role_id

RolePermission

Columns

	Name	Type	Autoinc	Nullable	Default	Unique	Indexed
pk	id	uuid(16)			uuid_generate_v4()	primary
fk	role_id	varchar(20)				role_permissions_role_id_permission_id_key
fk	permission_id	varchar(20)				role_permissions_role_id_permission_id_key

Relationships

Name	Class	Relation type	Cascade on	Condition
permission	Permission	belongs_to		permission_id => permission.permission_id
role	Role	belongs_to		role_id => role.role_id

User

Columns

	Name	Type	Autoinc	Nullable	Default	Unique	Indexed
pk	user_id	uuid(16)			uuid_generate_v4()	primary
	user_name	varchar(20)
	user_mobile_number	varchar(20)
	user_email	varchar(20)		yes
	user_password	varchar(50)		yes
	generated	integer		yes	date_part('epoch'::text, now())

Relationships

Name	Class	Relation type	Cascade on	Condition
contacts	Contact	has_many		user_id => contacts.user_id
user_roles	UserRole	has_many		user_id => user_roles.user_id

UserPic

Columns

	Name	Type	Autoinc	Nullable	Default	Unique	Indexed
pk	id	uuid(16)			uuid_generate_v4()	primary
fk	contact_id	uuid(16)
	profile_pic	text		yes

Relationships

Name	Class	Relation type	Cascade on	Condition
Missing reverse relation contact	Contact	belongs_to		contact_id => contact.id

UserRole

Columns

	Name	Type	Autoinc	Nullable	Default	Unique	Indexed
pk	id	uuid(16)			uuid_generate_v4()	primary
fk	user_id	uuid(16)				user_roles_user_id_role_id_key
fk	role_id	varchar(20)				user_roles_user_id_role_id_key

Relationships

Name	Class	Relation type	Cascade on	Condition
role	Role	belongs_to		role_id => role.role_id
user	User	belongs_to		user_id => user.user_id

Powered by Mojolicious::Plugin::DbicSchemaViewer