BreadPilgrimage

Tables (8)

Inquiry (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • member_id (Key2) — long — Foreign key → member.id — NOT NULL
  • title (Field)
  • description (Text)

bakery (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • businessHours (Field2)
  • location (Field3)
  • phonenum (Field4)

bread (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • bakery_id (Key2) — Foreign key → bakery.id — NOT NULL
  • Field

bread_review (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • member'_id (Key3) — long — Foreign key → member.id — NOT NULL
  • bread_id (Key22) — Foreign key → bread.bakery_id — NOT NULL
  • Field

bread_review_image (Untitled4)

  • Key — Primary key — NOT NULL
  • bread_review_id (Key2) — Foreign key → bread_review.id — NOT NULL
  • Field

member (Untitled)

  • id (Key) — long — Primary key — NOT NULL
  • name (Field) — string
  • nickname (Field2)
  • userId (Field3)
  • password (Field4)
  • image (Field5)
  • bio (Field6)
  • status (Field8)

member_bakery (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • store_id (Key3) — Foreign key → bakery.id — NOT NULL
  • member_id (Key2) — long — Foreign key → member.id — NOT NULL
  • Field

member_bread (Untitled8)

  • id (Key) — Primary key — NOT NULL
  • member_id (Key2) — Foreign key → member.id — NOT NULL
  • bread_id (Key3) — Foreign key → bread.id — NOT NULL
  • id (Key22) — Foreign key → bread.bakery_id — NOT NULL
  • Field