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