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