Display relational schemas here Show me list of tables, columns, and constraints (PKs, FKs)

Upload the projects relational schemas here. 

Show me the list of tables, columns, and constraints (PKs, FKs) created for your projects.

Data: 1)List attributes for your listed entities (PKs, FKs, Composite, and derived if any)

Professional Staff:

Staff ID Primary key

Staff Type (Picklist): (Pharmacist, Physician, Midwives, Nurse Practitioner, Registered Nurse, Patient, Medical Technician)

Name

Specialization

Non-Professional Staff:

Staff ID Primary key

Name

Type of staff (Picklist): (office Admin, Receptionist, Bookkeeper)

Patient Details:

Patient ID Primary Key

Contact Details

Medical History

Guardian Name

Insurance Details

Appointment:

Appointment id: Primary key

Patient id: Foreign key

Coverage Schedule:

Schedule ID (Primary Key)

Schedule Time

Staff Id (Foreign Key)

Patient Monthly details:

Statement id (Primary Key)

Patient id (Foreign Key)

Balance

Payments Received

Daily Laboratory Log

ID (Primary key)

Date

Records

Master Schedule

Practitioner ID (Primary)

Patient Id (Foreign)

Date

Walk-ins

Insurance Provider

Insurance Id (Primary Key)

Clinic Information

Practioner Information

Visit ID (Foreign key)

Type of Visit

Operating Log

Log id (Primary key)

Date

Surgery Details

Operating Room schedule

Schedule Id (Primary Key)

Date

Surgery Info

Delivery Log

Log id (Primary key)

Delivery Information

Date

Recovery Room Log

Log id (Primary Key)

Recovery Details

Date

Monthly Activity Log

Report Id (Primary Key)

Month-Year

Activity Centric Details

Facility

Facility Id (Primary Key)

Type of Facility

Prescription

Rx Number (Primary Key)

Patient id (Foreign Key)

Patient Information

Doctor Name

Total Price

Balance Due

2)List relationships (1:1, 1:M, and M:M if any)

§Staff – Coverage Schedule (One to Many Relationship)

§Patient – Appointment (One to Many Relationship)

§Patient – patient Monthly statement (One to Many Relationship)

§Practitioner Provider’s statement (One to Many Relationship)

§Professional staff Appointment (One to Many Relationship)

Please make sure Physician, Midwives, NP, RN should all be in one entity called Staff. How would you operate the visits? A patients calls in to schedule an appt. a Staff will conduct the visit. Visit will use many rooms (1: M) Visits will have referral, Visits will incur charges Visits will produce prescriptions (for Medicine or for Labs), diagnostics, procedures, labs.

Tool: Please use oracle