Python Django Medical Store Management System Part 2 | Project and Database Model Setup

Python Django Medical Store Management System Part 2 |  Project and Database Model Setup

Python Django Medical Store Management System Part 2 |  Project and Database Model Setup

Tutorial Cover : 

1. How to Create Project in Django

2. How to Create App in Django

3. Create Database Models Class in Django

4. Link Database Model to Admin Panel

5. Run Migration Command

6. Run Project

7. Medical Store Management System Database Model Setup

8. Django Model AutoField,CharField,InterField,Primary Key,Foreign Key

Tutorial Link : https://youtu.be/83NOTkDh9yg

Join Our Telegram Group for Stay Updated : https://t.me/supercoders

Source Code : https://github.com/hackstarsj/DjangoMedicalStoreManagementSystem

models.py

	from django.db import models
	# Create your models here.
	class Company(models.Model):
	id=models.AutoField(primary_key=True)
	name=models.CharField(max_length=255)
	license_no=models.CharField(max_length=255)
	address=models.CharField(max_length=255)
	contact_no=models.CharField(max_length=255)
	email=models.CharField(max_length=255)
	description=models.CharField(max_length=255)
	added_on=models.DateTimeField(auto_now_add=True)
	objects=models.Manager()
	class Medicine(models.Model):
	id=models.AutoField(primary_key=True)
	name=models.CharField(max_length=255)
	medical_typ=models.CharField(max_length=255)
	buy_price=models.CharField(max_length=255)
	sell_price=models.CharField(max_length=255)
	c_gst=models.CharField(max_length=255)
	s_gst=models.CharField(max_length=255)
	batch_no=models.CharField(max_length=255)
	shelf_no=models.CharField(max_length=255)
	expire_date=models.DateField()
	mfg_date=models.DateField()
	company_id=models.ForeignKey(Company,on_delete=models.CASCADE)
	description=models.CharField(max_length=255)
	in_stock_total=models.IntegerField()
	qty_in_strip=models.IntegerField()
	added_on=models.DateTimeField(auto_now_add=True)
	objects=models.Manager()
	class MedicalDetails(models.Model):
	id=models.AutoField(primary_key=True)
	medicine_id=models.ForeignKey(Medicine,on_delete=models.CASCADE)
	salt_name=models.CharField(max_length=255)
	salt_qty=models.CharField(max_length=255)
	salt_qty_type=models.CharField(max_length=255)
	description=models.CharField(max_length=255)
	added_on=models.DateTimeField(auto_now_add=True)
	objects=models.Manager()
	class Employee(models.Model):
	id=models.AutoField(primary_key=True)
	name=models.CharField(max_length=255)
	joining_date=models.DateField()
	phone=models.CharField(max_length=255)
	address=models.CharField(max_length=255)
	added_on=models.DateTimeField(auto_now_add=True)
	objects=models.Manager()
	class Customer(models.Model):
	id=models.AutoField(primary_key=True)
	name=models.CharField(max_length=255)
	address=models.CharField(max_length=255)
	contact=models.CharField(max_length=255)
	added_on=models.DateTimeField(auto_now_add=True)
	objects=models.Manager()
	class Bill(models.Model):
	id=models.AutoField(primary_key=True)
	customer_id=models.ForeignKey(Customer,on_delete=models.CASCADE)
	added_on=models.DateTimeField(auto_now_add=True)
	objects=models.Manager()
	class EmployeeSalary(models.Model):
	id=models.AutoField(primary_key=True)
	employee_id=models.ForeignKey(Employee,on_delete=models.CASCADE)
	salary_date=models.DateField()
	salary_amount=models.CharField(max_length=255)
	added_on=models.DateTimeField(auto_now_add=True)
	objects=models.Manager()
	class BillDetails(models.Model):
	id=models.AutoField(primary_key=True)
	bill_id=models.ForeignKey(Bill,on_delete=models.CASCADE)
	medicine_id=models.ForeignKey(Medicine,on_delete=models.CASCADE)
	qty=models.IntegerField()
	added_on=models.DateTimeField(auto_now_add=True)
	objects=models.Manager()
	class CustomerRequest(models.Model):
	id=models.AutoField(primary_key=True)
	customer_name=models.CharField(max_length=255)
	phone=models.CharField(max_length=255)
	medicine_details=models.CharField(max_length=255)
	status=models.BooleanField(default=False)
	added_on=models.DateTimeField(auto_now_add=True)
	prescription=models.FileField(default="")
	objects=models.Manager()
	class CompanyAccount(models.Model):
	choices=((1,"Debit"),(2,"Credit"))
	id=models.AutoField(primary_key=True)
	company_id=models.ForeignKey(Company,on_delete=models.CASCADE)
	transaction_type=models.CharField(choices=choices,max_length=255)
	transaction_amt=models.CharField(max_length=255)
	transaction_date=models.DateField()
	payment_mode=models.CharField(max_length=255)
	added_on=models.DateTimeField(auto_now_add=True)
	objects=models.Manager()
	class CompanyBank(models.Model):
	id=models.AutoField(primary_key=True)
	bank_account_no=models.CharField(max_length=255)
	ifsc_no=models.CharField(max_length=255)
	company_id=models.ForeignKey(Company,on_delete=models.CASCADE)
	added_on=models.DateTimeField(auto_now_add=True)
	objects=models.Manager()
	class EmployeeBank(models.Model):
	id=models.AutoField(primary_key=True)
	bank_account_no=models.CharField(max_length=255)
	ifsc_no=models.CharField(max_length=255)
	employee_id=models.ForeignKey(Employee,on_delete=models.CASCADE)
	added_on=models.DateTimeField(auto_now_add=True)
	objects=models.Manager()

view raw models.py delivered with ❤ by emgithub

admin.py

	from django.contrib import admin
	# Register your models here.
	from DjangoMedicalApp.models import Company, Medicine, EmployeeSalary, BillDetails, CustomerRequest, CompanyAccount, \
	CompanyBank, EmployeeBank, Bill, Customer, Employee, MedicalDetails
	admin.site.register(Company)
	admin.site.register(Medicine)
	admin.site.register(MedicalDetails)
	admin.site.register(Employee)
	admin.site.register(Customer)
	admin.site.register(Bill)
	admin.site.register(EmployeeSalary)
	admin.site.register(BillDetails)
	admin.site.register(CustomerRequest)
	admin.site.register(CompanyAccount)
	admin.site.register(CompanyBank)
	admin.site.register(EmployeeBank)

view raw admin.py delivered with ❤ by emgithub