blossom
Tables (12)
partner (Untitled4)
- id (Key2) — Primary key — NOT NULL
- user_id (Key) — Foreign key → user.id — NOT NULL
- name (Field3)
- phone (Field4)
- description (Field5)
- address (Field)
- coordinates (Field2)
- created_at (Field6)
- updated_at (Field7)
partner_design (Untitled8)
- id (Key) — Primary key — NOT NULL
- partner_id (Key2) — Foreign key → partner.id — NOT NULL
- view (Field)
- image_path (Field4)
- created_at (Field2)
- updated_at (Field3)
partner_design_tag (Untitled10)
- id (Key) — Primary key — NOT NULL
- design_id (Key2) — Foreign key → partner_design.id — NOT NULL
- tag (Field)
partner_image (Untitled9)
- id (Key) — Primary key — NOT NULL
- partner_id (Key2) — Foreign key → partner.id — NOT NULL
- image_path (Field)
partner_menu (Untitled7)
- partner_id (Key2) — Foreign key → partner.id — NOT NULL
- title (Field)
- price (Field2)
partner_open_time (Untitled5)
- id (Key) — Primary key — NOT NULL
- partner_id (Key2) — Foreign key → partner.id — NOT NULL
- date (Field)
- time (Field2)
partner_tag (Untitled6)
- id (Key) — Primary key — NOT NULL
- partner_id (Key2) — Foreign key → partner.id — NOT NULL
- tag (Field)
role (Untitled2)
- id (Key) — Primary key — NOT NULL
- role (Field)
user (Untitled)
- id (Key) — Primary key — NOT NULL
- username (Field)
- phone (Field6)
- email (Field2)
- password (Field3)
- created_at (Field4)
- updated_at (Field5)
user_design_like (Untitled12)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → user.id — NOT NULL
- design_id (Key3) — Foreign key → partner_design.id — NOT NULL
user_partner_like (Untitled11)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → user.id — NOT NULL
- partner_id (Key22) — Foreign key → partner.id — NOT NULL
user_role (Untitled3)
- user_id (Key) — Foreign key → user.id — NOT NULL
- role_id (Key2) — Foreign key → role.id — NOT NULL