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