APillZ

Tables (18)

banners

  • id — bigint
  • image_id — bigint — Foreign key → files.id
  • type — string

categories

  • id — bigint
  • name — string

compares

  • id — bigint
  • product_id — bigint — Foreign key → products.id
  • created_by — bigint — Foreign key → users.id

educations

  • id — bigint
  • user_id — bigint — Foreign key → users.id
  • school — string
  • major — string
  • start — string
  • end — string

events

  • id — bigint
  • start_date — date
  • end_date — date
  • image_id — bigint — Foreign key → files.id
  • title — string
  • content — text
  • created_by — bigint

files

  • id — bigint — Foreign key → users.avatar_id
  • key — string
  • url — string
  • status — string
  • file_name — string
  • mine_type — string
  • created_by — bigint
  • created_at — datetime
  • updated_at — datetime

ingredients

  • id — bigint
  • name — string
  • description — text
  • recommended_amount — float

likes

  • id — bigint
  • product_id — bigint — Foreign key → products.id
  • created_by — bigint — Foreign key → users.id
  • status — boolean

notices

  • id — bigint
  • title — string
  • content — text

product_ingredients

  • id — bigint
  • product_id — bigint — Foreign key → products.id
  • ingredient_id — bigint — Foreign key → ingredients.id
  • amount — float

product_requests

  • id — bigint
  • image_id — bigint — Foreign key → files.id
  • name — string
  • manufacture — string

product_reviews

  • id — bigint
  • product_id — bigint — Foreign key → products.id
  • rating — integer
  • created_by — bigint
  • content — text
  • is_private_profile — boolean

products

  • id — bigint
  • name — string
  • image_id — bigint — Foreign key → products.id
  • pdf_id — bigint
  • category_id — bigint — Foreign key → categories.id
  • type — integer
  • manufacture — string
  • effect — string
  • recommended_dosage — string

sellers

  • id — bigint
  • name — string
  • link — string
  • price — integer
  • product_id — bigint — Foreign key → products.id

takings

  • id — bigint
  • user_id — bigint — Foreign key → users.id
  • product_id — bigint

users

  • id — bigint — Foreign key → files.created_by
  • email — email
  • password — string
  • avatar_id — bigint
  • username — string
  • full_name — string
  • phone_number — string
  • gender — string
  • birthday — date
  • license_number — integer
  • license_image_id — bigint
  • introduction — text
  • phamacy_name — string
  • address — string
  • address_detail — string
  • phamacy_phone_number — string
  • facebook_url — string
  • navar_url — string
  • is_public_profile — boolean
  • status — integer

wholesales

  • id — bigint
  • created_by — bigint
  • date — date
  • address — string
  • price — integer
  • product_id — bigint — Foreign key → products.id

work_experiences

  • id — bigint
  • user_id — bigint — Foreign key → users.id
  • company — string
  • position — string
  • start — string
  • end — string