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