project1

Tables (12)

category (Untitled11)

  • PK (category_ID) — varchar(10) — Primary key — NOT NULL
  • Field (category_name) — varchar(10)

inquiry (Untitled7)

  • PK (inquiry_ID) — varchar(10) — Primary key — NOT NULL
  • Field (title) — varchar(50)
  • Field (description) — description
  • Field (photo) — varchar(20)
  • PK (ID2) — varchar(10) — Foreign key → user.PK — NOT NULL

inquiry-to-photo (Untitled10)

  • PK (photo_ID) — varchar(10) — Foreign key → photo.PK — NOT NULL
  • PK (inquiry_ID) — varchar(10) — Foreign key → inquiry.PK — NOT NULL

photo (Untitled8)

  • PK (photo_ID) — varchar(10) — Primary key — NOT NULL
  • Field (photo_path) — varchar(20)

point (Untitled4)

  • PK (point_ID) — varchar(10) — Primary key — NOT NULL
  • Field (date) — datetime
  • Field (point) — decimal
  • Field (restaurant) — varchar(30)
  • Field
  • PK (ID2) — varchar(10) — Foreign key → user.PK — NOT NULL
  • PK (restaurant_ID) — varchar(10) — Foreign key → restaurant.PK — NOT NULL

prefer (Untitled5)

  • PK (prefer_ID) — varchar(10) — Primary key — NOT NULL
  • Field (prefer_name) — varchar(20)

restaurant (Untitled2)

  • PK (restaurant_ID) — varchar(10) — Primary key — NOT NULL
  • Field (name) — varchar(20)
  • Field (point) — bigint
  • Field (limit) — daytime
  • Field (category) — varchar(10)
  • Field (address) — varchar(30)
  • Field (review) — text

restaurant-to-category (Untitled12)

  • PK (restaurant_ID) — varchar(10) — Foreign key → restaurant.PK — NOT NULL
  • PK (category_ID) — varchar(10) — Foreign key → category.PK — NOT NULL

review (Untitled3)

  • PK (review_ID) — varchar(10) — Primary key — NOT NULL
  • Field (star) — decimal
  • Field (date) — datetime
  • Field (description) — text
  • Field (photo) — varchar(20)
  • PK (ID2) — varchar(10) — Foreign key → user.PK — NOT NULL

review-to-photo (Untitled9)

  • PK (review_ID) — varchar(10) — Foreign key → review.PK — NOT NULL
  • PK (photo_ID) — varchar(10) — Foreign key → photo.PK — NOT NULL

user (Untitled)

  • PK (ID) — varchar(10) — Primary key — NOT NULL
  • Field (name) — varchar(10)
  • Field (gender) — int
  • Field (birth) — bigint
  • Field (address) — varchar(20)
  • Field (prefer) — varchar(20)
  • Field (goal) — int
  • Field (point) — bigint
  • Field (review) — text
  • Field (inquiry) — text

user-to-prefer (Untitled6)

  • PK (prefer_ID) — varchar(10) — Foreign key → prefer.PK — NOT NULL
  • PK (ID2) — varchar(10) — Foreign key → user.PK — NOT NULL