restraunt
Tables (9)
comment (Untitled4)
- id (Key) — Long — Primary key — NOT NULL
- content (Field) — varchar
- Field2
- user_id (Key2) — Long — Foreign key → user.id — NOT NULL
- review_id (Key3) — Long — Foreign key → review.id — NOT NULL
image (Untitled2)
- id (Key) — Long — Primary key — NOT NULL
- url (Field) — varchar
- type (Field2) — varchar
- Field3
- user_id (Key2) — Long — Foreign key → user.id — NOT NULL
- restraunt_id (Key3) — Long — Foreign key → restraunt.id — NOT NULL
menu (Untitled7)
- id (Key) — Long — Primary key — NOT NULL
- name (Field) — varchar
- price (Field2) — int
- restraunt_id (Key2) — Long — Foreign key → restraunt.id — NOT NULL
recommend (Untitled8)
- id (Key) — Long — Primary key — NOT NULL
- restraunt_id (Key2) — Long — Foreign key → restraunt.id — NOT NULL
restraunt (Untitled6)
- id (Key) — Long — Primary key — NOT NULL
- title (Field) — varchar
- address (Field2) — varchar
- latitude (Field3) — float
- longitude (Field4) — float
- content (Field5) — varchar
- open_date (Field6) — datetime
- close_date (Field7) — datetime
- average_price (Field8) — int
- review_count (Field9) — int
review (Untitled3)
- id (Key) — Long — Primary key — NOT NULL
- register_date (Field) — datetime
- content (Field2) — varchar
- score (Field3) — float
- like_count (Field4) — int
- Field5
- user_id (Key2) — Long — Foreign key → user.id — NOT NULL
- restraunt_Id (Key3) — Long — Foreign key → restraunt.id — NOT NULL
search (Untitled9)
- id (Key) — Long — Primary key — NOT NULL
- Field
tag (Untitled5)
- id (Key) — Long — Primary key — NOT NULL
- name (Field) — varchar
- Field2
- restaunt_id (Key2) — Long — Foreign key → restraunt.id — NOT NULL
user (Untitled)
- id (Key) — Long — Primary key — NOT NULL
- nickname (Field) — varchar
- username (Field2) — varchar
- password (Field3) — varchar
- post_code (Field4) — varchar
- address (Field5) — varchar
- phone_number (Field6) — varchar
- email (Field7) — varchar
- google_id (Field8) — varchar
- naver_id (Field9) — varchar
- social_provider (Field10) — varchar
- Field11