Scribd
Upload
28 views2 pages

Name Null / Not Null Type Key: Bill Table

The document describes the structure of several database tables related to a hospital management system including tables for bills, patients, outpatients, laboratories, doctors, rooms, and inpatients with details on column names, data types, and primary and foreign keys.

Uploaded by

Abhinav Arora
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
28 views2 pages

Name Null / Not Null Type Key: Bill Table

The document describes the structure of several database tables related to a hospital management system including tables for bills, patients, outpatients, laboratories, doctors, rooms, and inpatients with details on column names, data types, and primary and foreign keys.

Uploaded by

Abhinav Arora
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/ 2

Name Null / Not Null Type Key

Bill_no Null Varchar(30) Primary


Patient_id Null Varchar (30) Foreign
doctor_change Null Varchar (30)
room_change Null Varchar (30)
no_of_days Null Varchar (30)
Bill Table

Patient Table

Name Null / Not Null Type Key


Patient_id Null Integer (30) Primary
Name Null Varchar (30)
age Null Integer (30)
Gender Null Varchar (30)
Address Null Varchar (30)
Disease Null Varchar (30)
Doctor_id Not Null Varchar (30) Foreign

Outpatient Table

Name Null / Not Null Type Key


Patient_id Null Varchar (30) Primary
Date Null Date
Report Null Boolean (30)

Laboratory Table

Name Null / Not Null Type Key


Lab_no Null Varchar (30) Primary
Patient_id Null Varchar (30) Foreign
doctor_id Null Varchar (30) Foreign
Date Null DateTime (30)
amount Null decimal (255)
Doctor Table

Name Null / Not Null Type Key


Doctor_id Null Varchar (30) Primary
Name Null string (30)
age Null integer (30)
Gender Null Varchar (30)
Address Null Varchar (30)

Room Table

Name Null / Not Null Type Key


Room_no Null Varchar (30) Primary
Room_type Null Varchar (30)
Status Null Varchar (30)

In Patient Table

Name Null / Not Null Type Key


Patient_id Null Varchar (30) Primary
Room_no Null integer Foreign
Date_of_adm Null Date
Date_of_dis Null Date

You might also like