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