[go: up one dir, main page]
Scribd
Upload
13 views12 pages

Data Repository

The document outlines the database schema for a user registration system, detailing fields for user, admin, seller profiles, and associated entities like products, orders, payments, and feedback. Each section specifies field names, data types, lengths, constraints, and descriptions to ensure proper data management. This structured approach facilitates efficient handling of user interactions and transactions within the system.

Uploaded by

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

Data Repository

The document outlines the database schema for a user registration system, detailing fields for user, admin, seller profiles, and associated entities like products, orders, payments, and feedback. Each section specifies field names, data types, lengths, constraints, and descriptions to ensure proper data management. This structured approach facilitates efficient handling of user interactions and transactions within the system.

Uploaded by

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

REGISTRATION FOR USER

Field Name Data Type Field Length Constraint Description


reg_id int 5 Primary key It stores id of registration.
user_id int 5 Foreign key It stores id of user.
user_full_name varchar 30 Not null It stores full name of user.
user_username varchar 10 Unique It stores username of user.
user_password varchar 10 Unique It stores password of user.
user_email varchar 30 Unique It stores email of user.
user_phone int 10 Unique It stores phone number of user.
reg_timestamp time 9 Not null It stores time of registration.
USER PROFILE
Field Name Data Type Field Length Constraint Description
user_id int 5 Primary key It stores id of user.
user_full_name varchar 30 Not null It stores full name of user.
user_username varchar 10 Unique It stores username of user.
user_password varchar 10 Not null It stores password of user.
user_email varchar 30 Unique It stores email address of user.
user_phone int 10 Unique It stores phone number of user.
user_address varchar 100 Not null It stores address of user.
user_pincode int 6 Not null It stores pin code of user.
REGISTRATION FOR ADMIN / SELLER
Field Name Data Type Field Length Constraint Description
reg_id int 5 Primary key It stores id of registration.
admin_id int 5 Primary key It stores id of admin.
admin_full_name varchar 30 Not null It stores full name of admin.
admin_email varchar 30 Unique It stores email of admin.
admin_password varchar 10 Not null It stores password of admin.
admin_permission_level varchar 20 Not null It stores level of permission of admin.
seller_id int 5 Foreign key It stores id of seller.
seller_name varchar 20 Not null It stores name of seller.
seller_business_name varchar 30 Not null It stores business name of seller.
seller_email varchar 30 Unique It stores email of seller.
seller_password varchar 10 Unique It stores password of seller.
seller_phone int 10 Unique It stores phone number of seller.
reg_role varchar 10 Not null It stores role of registrant.
reg_timestamp time 9 Not null It stores time of registration.
ADMIN PROFILE

Field Name Data Type Field Length Constraint Description


admin_id int 5 Primary key It stores id of admin.
admin_full_name varchar 30 Not null It stores full name of admin.
admin_email varchar 30 Unique It stores email of admin.
admin_password varchar 10 Not null It stores password of admin.
admin_permission_level varchar 20 Not null It stores level of permission of admin.
SELLER PROFILE
Field Name Data Type Field Length Constraint Description
seller_id int 5 Primary key It stores id of seller.
seller_name varchar 15 Not null It stores name of seller.
seller_business_name varchar 30 Not null It stores business name of seller.
seller_email varchar 30 Unique It stores email of seller.
seller_password varchar 10 Unique It stores password of seller.
seller_phone int 10 Unique It stores phone number of seller.
seller_address varchar 100 Not null It stores address of seller.
seller_pincode int 6 Not null It stores pin code of seller.
CATEGORY

Field Name Data Type Field Length Constraint Description


category_id int 5 Primary key It stores id of category.
category_name varchar 20 Not null It stores name of category.
admin_id int 5 Foreign key It stores id of admin.
PRODUCT
Field Name Data Field Length Constraint Description
Type
product_id int 5 Primary key It stores id of product.
product_name varchar 20 Not null It stores name of product.
category_id int 5 Foreign key It stores id of category.
product_description varchar 50 Not null It stores description of product.
product_quantity int 10 Not null It stores quantity of product.
product_price int 8 Not null It stores price of product.
seller_id int 5 Foreign key It stores id of seller.
product_image varchar 255 Not null It stores url of image of product.
product_weight int 5 Not null It stores weight of product.
product_dimensions varchar 20 Not null It stores dimensions of product.
product_status varchar 30 Not null It stores status of product.
ORDER
Field Name Data Type Field Length Constraint Description
order_id int 5 Primary key It stores id of order.
user_id int 5 Foreign key It stores id of user.
product_id int 5 Foreign key It stores id of product.
seller_id int 5 Foreign key It stores id of seller.
order_placed_date date 10 Not null It stores placed date of order.
order_last_date date 10 Not null It stores last date of order.
order_address varchar 100 Not null It stores address of order.
order_timestamp time 9 Not null It stores time of order.
order_amount int 8 Not null It stores amount of order.
PAYMENT

Field Name Data Type Field Length Constraint Description


payment_id int 5 Primary key It stores id of payment.
user_id int 5 Foreign key It stores id of user.
order_id int 5 Foreign key It stores id of order.
payment_method varchar 20 Not null It stores method of payment.
payment_details varchar 30 Not null It stores details of payment.
payment_amount int 8 Not null It stores amount of payment.
payment_timestamp time 9 Not null It stores time of payment.
CANCEL ORDER

Field Name Data Type Field Length Constraint Description


cancel_order_id int 5 Primary key It stores id of cancel order.
order_id int 5 Foreign key It stores id of order.
user_id int 5 Foreign key It stores id of user.
payment_id int 5 Foreign key It stores id of payment.
cancel_order_timestamp time 9 Not null It stores time of cancel order.
STOCK MANAGEMENT
Field Name Data Type Field Length Constraint Description
stock_id int 5 Primary key It stores id of stock.
stock_name varchar 10 Not null It stores name of stock.
category_id int 5 Foreign key It stores id of category.
admin_id int 5 Foreign key It stores id of admin.
seller_id int 5 Foreign key It stores id of seller.
stock_quantity int 10 Not null It stores quantity of stock.
purchase_price int 8 Not null It stores purchase price.
selling_price int 8 Not null It stores selling price.
date_added date 10 Not null It stores date of added stock.
last_updated date 10 Not null It stores date of updated stock.
stock_status varchar 30 Not null It stores status of stock.
FEEDBACK

Field Name Data Type Field Length Constraint Description


feedback_id int 5 Primary key It stores id of feedback.
user_id int 5 Foreign key It stores id of user.
order_id int 5 Foreign key It stores id of order.
feedback_details varchar 20 Not null It stores details of feedback.
feedback_rating int 1 Not null It stores rating of feedback.

You might also like