mypd
Tables (50)
about_investor
- id — int(10) — Primary key — NOT NULL
- year — int(10)
- name — varchar(250) — NOT NULL
- filename — varchar(250) — NOT NULL
- fk_category — int(10) — Foreign key → about_investor_category.id — NOT NULL
about_investor_category
- id — int(10) — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
- img — varchar(50) — NOT NULL
about_overview
- id — int(10) — Primary key — NOT NULL
- overview — text
- visi — text
about_section
- id — int(10) — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
about_slider
- idabout_slider — int(11) — Primary key — NOT NULL
- img — text
- position — int(11)
about_team
- id — int(10) — Primary key — NOT NULL
- name — varchar(250) — NOT NULL
- title — varchar(250) — NOT NULL
- img — varchar(250) — NOT NULL
- fk_section — int(10) — Foreign key → about_section.id — NOT NULL
ask_doctor
- id — int(10) — Primary key — NOT NULL
- full_name — varchar(50) — NOT NULL
- phone_number — varchar(50) — NOT NULL
- email — varchar(50) — NOT NULL
- question — text — NOT NULL
- answer — text
- fk_doctor — int(10) — Foreign key → bankdoctor.id_doctor
- fk_category — int(10) — Foreign key → bankspecialities.iddoc_specialities — NOT NULL
- fk_hospital — int(10) — Foreign key → bankhospital.idhospital_branch — NOT NULL
- fk_status — int(10) — Foreign key → ask_doctor_status.id — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
ask_doctor_status
- id — int(10) — Primary key — NOT NULL
- name — varchar(250) — NOT NULL
bankdoctor
- id_doctor — int(10) — Primary key — NOT NULL
- doc_name — varchar(200)
- doc_photo — varchar(200)
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
bankfacilities
- idBankFacilities — int(10) — Primary key — NOT NULL
- facilities_name — varchar(100)
bankhospital
- idhospital_branch — int(10) — Primary key — NOT NULL
- hospital_name — varchar(200)
- hospital_desc — text
- img — varchar(200)
bankpromo
- idpromo — int(10) — Primary key — NOT NULL
- promo_name — varchar(45)
bankspecialities
- iddoc_specialities — int(10) — Primary key — NOT NULL
- specialities_name — varchar(100)
bookingorder
- idbookingOrder — int(10) — Primary key — NOT NULL
- first_name — varchar(50) — NOT NULL
- last_name — varchar(50) — NOT NULL
- birth_date — date — NOT NULL
- phone_number — varchar(50) — NOT NULL
- email — varchar(50) — NOT NULL
- booking_date — date — NOT NULL
- hospital_name — varchar(50) — NOT NULL
- speciality — varchar(50) — NOT NULL
- doctor_name — varchar(50) — NOT NULL
- time — varchar(50) — NOT NULL
- bookingOrderStatus_idbookingOrderStatus — int(10) — Foreign key → bookingorderstatus.idbookingOrderStatus — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
bookingorderstatus
- idbookingOrderStatus — int(10) — Primary key — NOT NULL
- statusName — varchar(45)
category
- id — int(10) — Primary key — NOT NULL
- name — varchar(250) — NOT NULL
- color — varchar(10) — NOT NULL
category_promo
- id — int(10) — Primary key — NOT NULL
- name — varchar(250) — NOT NULL
- color — varchar(10) — NOT NULL
coe
- id — int(11) — Primary key — NOT NULL
- name — varchar(250)
- icon — varchar(250)
- img — varchar(250)
- desc — text
doc_schedule
- iddoc_schedule — int(10) — Primary key — NOT NULL
- timeStart — varchar(50)
- timeEnd — varchar(50)
- weekDaysname_idweekDaysname — int(10) — Foreign key → weekdaysname.idweekDaysname — NOT NULL
- Bankdoctor_id_doctor — int(10) — Foreign key → bankdoctor.id_doctor — NOT NULL
- bankHospital_idhospital_branch — int(10) — Foreign key → bankhospital.idhospital_branch — NOT NULL
docinterest
- iddocInterest — int(10) — Primary key — NOT NULL
- name — text
- Bankdoctor_id_doctor — int(10) — Foreign key → bankdoctor.id_doctor — NOT NULL
gallery
- idGallery — int(10) — Primary key — NOT NULL
- img — varchar(225)
- bankHospital_idhospital_branch — int(10) — Foreign key → bankhospital.idhospital_branch — NOT NULL
hospital_slider
- id — int(10) — Primary key — NOT NULL
- img — varchar(250) — NOT NULL
- position — int(10) — NOT NULL
- fk_hospital — int(10) — Foreign key → bankhospital.idhospital_branch — NOT NULL
indonesia_cities
- id — char(4) — Primary key — NOT NULL
- province_id — char(2) — NOT NULL
- name — varchar(255) — NOT NULL
- meta — text
- created_at — timestamp
- updated_at — timestamp
indonesia_districts
- id — char(7) — Primary key — NOT NULL
- city_id — char(4) — NOT NULL
- name — varchar(255) — NOT NULL
- meta — text
- created_at — timestamp
- updated_at — timestamp
indonesia_provinces
- id — char(2) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- meta — text
- created_at — timestamp
- updated_at — timestamp
indonesia_villages
- id — char(10) — Primary key — NOT NULL
- district_id — char(7) — NOT NULL
- name — varchar(255) — NOT NULL
- meta — text
- created_at — timestamp
- updated_at — timestamp
merge_coe_location
- id — int(11) — Primary key — NOT NULL
- fk_hospital — int(10) — Foreign key → bankhospital.idhospital_branch
- fk_coe — int(11) — Foreign key → coe.id
merge_doc_detail_specialities
- id_merge_doc_detail_specialities — int(11) — Primary key — NOT NULL
- doctor_id — int(11) — Foreign key → bankdoctor.id_doctor — NOT NULL
- specialities_id — int(11) — Foreign key → bankspecialities.iddoc_specialities — NOT NULL
merge_doc_specialties_hospital
- idmerge_doc_specialties — int(10) — Primary key — NOT NULL
- doc_specialities_iddoc_specialities — int(10) — Foreign key → bankspecialities.iddoc_specialities — NOT NULL
- doctor_id_doctor — int(10) — Foreign key → bankdoctor.id_doctor — NOT NULL
- hospital_branch_idhospital_branch — int(10) — Foreign key → bankhospital.idhospital_branch — NOT NULL
merge_doctor_hospital
- id — int(11) — Primary key — NOT NULL
- fk_hospital — int(10)
- fk_doctor — int(11)
merge_hospital_facilities
- idmerge_hospital_facilities — int(10) — Primary key — NOT NULL
- hospital_branch_idhospital_branch — int(10) — Foreign key → bankhospital.idhospital_branch — NOT NULL
- BankFacilities_idBankFacilities — int(10) — Foreign key → bankfacilities.idBankFacilities — NOT NULL
merge_news_location
- id — int(11) — Primary key — NOT NULL
- fk_hospital — int(10) — Foreign key → bankhospital.idhospital_branch
- fk_news — int(11) — Foreign key → news.idnews
merge_promo_location
- id — int(11) — Primary key — NOT NULL
- fk_hospital — int(10) — Foreign key → bankhospital.idhospital_branch
- fk_promo — int(11) — Foreign key → promo.id
migrations
- id — int(10) — Primary key — NOT NULL
- migration — varchar(255) — NOT NULL
- batch — int(11) — NOT NULL
news
- idnews — int(10) — Primary key — NOT NULL
- hospital_branch_idhospital_branch — int(10)
- fk_category — int(10) — Foreign key → category.id — NOT NULL
- view_count — int(10) — NOT NULL
- title — varchar(250) — NOT NULL
- body — text — NOT NULL
- writer — varchar(50) — NOT NULL
- img — text — NOT NULL
- thumbnail — text — NOT NULL
- tag — varchar(250) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
news_featured
- id — int(11) — Primary key — NOT NULL
- fk_news — int(10) — Foreign key → news.idnews — NOT NULL
- position — int(11)
password_resets
- email — varchar(255) — NOT NULL
- token — varchar(255) — NOT NULL
- created_at — timestamp
profile
- idprofile — int(10) — Primary key — NOT NULL
- year — smallint(6)
- title — varchar(255)
- desc — text
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- profileCategory_idprofileCategory — int(10) — Foreign key → profilecategory.idprofileCategory — NOT NULL
- Bankdoctor_id_doctor — int(10) — Foreign key → bankdoctor.id_doctor — NOT NULL
profilecategory
- idprofileCategory — int(10) — Primary key — NOT NULL
- profileCategorycol — varchar(200)
promo
- id — int(10) — Primary key — NOT NULL
- fk_category — int(10) — Foreign key → category_promo.id — NOT NULL
- title — varchar(250) — NOT NULL
- body — text — NOT NULL
- expired_date — date — NOT NULL
- img — text — NOT NULL
- thumbnail — text — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
subscription
- id_subscription — int(11) — Primary key — NOT NULL
- email — varchar(255) — NOT NULL
tagging_tag_groups
- id — int(10) — Primary key — NOT NULL
- slug — varchar(125) — NOT NULL
- name — varchar(125) — NOT NULL
tagging_tagged
- id — int(10) — Primary key — NOT NULL
- taggable_id — int(10) — NOT NULL
- taggable_type — varchar(125) — NOT NULL
- tag_name — varchar(125) — NOT NULL
- tag_slug — varchar(125) — NOT NULL
tagging_tags
- id — int(10) — Primary key — NOT NULL
- slug — varchar(125) — NOT NULL
- name — varchar(125) — NOT NULL
- suggest — tinyint(1) — NOT NULL
- count — int(10) — NOT NULL
- tag_group_id — int(10)
testimony
- id — int(10) — Primary key — NOT NULL
- testi_name — varchar(250) — NOT NULL
- testi_short_desc — varchar(250) — NOT NULL
- testi_desc — text
- testi_img — varchar(250)
- hospital_branch_idhospital_branch — int(10) — Foreign key → bankhospital.idhospital_branch — NOT NULL
time
- id — int(10) — Primary key — NOT NULL
- time — varchar(50) — NOT NULL
users
- id — int(10) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- email_verified_at — timestamp
- password — varchar(255) — NOT NULL
- remember_token — varchar(100)
- created_at — timestamp
- updated_at — timestamp
videoads_homepage
- idvideoads_homepage — int(10) — Primary key — NOT NULL
- embed_youtube — text
- video_img_cover — varchar(200)
weekdaysname
- idweekDaysname — int(10) — Primary key — NOT NULL
- daysName — varchar(45)
year
- id — int(10) — Primary key — NOT NULL
- time — varchar(50) — NOT NULL