GoodRestaurant

Tables (11)

Adress (주소)

  • latitude (위도) — DOUBLE
  • longitude (경도) — DOUBLe
  • kaddress (도로명 주소) — VARCHAR(255)
  • id — Long — Foreign key → Pin.id — NOT NULL
  • email — varchar(255) — Foreign key → Pin.email — NOT NULL
  • email (email2) — varchar(255) — Foreign key → Pin.email — NOT NULL
  • id (id2) — LONG — Foreign key → Pin.id — NOT NULL

BOOKMARK (Untitled4)

  • email — varchar(255) — Foreign key → Users.email — NOT NULL

COMMENT_IMAGE (Untitled)

  • id — UUID — Primary key — NOT NULL
  • id (id2) — UUID — Foreign key → Comment.id — NOT NULL
  • id (id22) — Long — Foreign key → Comment.id — NOT NULL
  • email — varchar(255) — Foreign key → Comment.email — NOT NULL
  • email (email2) — varchar(255) — Foreign key → Comment.email — NOT NULL
  • email (email22) — varchar(255) — Foreign key → Comment.email — NOT NULL
  • email (email3) — varchar(255) — Foreign key → Comment.email — NOT NULL
  • id (id222) — LONG — Foreign key → Comment.id — NOT NULL
  • image_url — VARCHAR255

COMMENT_LIKE (Untitled5)

  • email — varchar(255) — Foreign key → Users.email — NOT NULL

Category (카테고리)

  • id — LONG — Primary key — NOT NULL
  • name — varchar(255)

Comment (댓글)

  • id — UUID — Primary key — NOT NULL
  • id (id2) — Long — Foreign key → Pin.id — NOT NULL
  • email — varchar(255) — Foreign key → Pin.email — NOT NULL
  • email (email2) — varchar(255) — Foreign key → Users.email — NOT NULL
  • email (email22) — varchar(255) — Foreign key → Pin.email — NOT NULL
  • email (email3) — varchar(255) — Foreign key → COMMENT_LIKE.email — NOT NULL
  • id (id22) — LONG — Foreign key → Pin.id — NOT NULL
  • comment — CLOB
  • grade — Double
  • TYPE — ENUM(NORMAL, REVIEW)
  • created_at — DATETIME
  • updated_at — DATETIME

PIN_TAG (Untitled3)

  • id — Long — Foreign key → Pin.id — NOT NULL
  • email — varchar(255) — Foreign key → Pin.email — NOT NULL
  • email (email2) — varchar(255) — Foreign key → Pin.email — NOT NULL
  • id (id2) — LONG — Foreign key → Pin.id — NOT NULL

Pin (핀)

  • id — Long — Primary key — NOT NULL
  • email — varchar(255) — Foreign key → Users.email — NOT NULL
  • email (email2) — varchar(255) — Foreign key → BOOKMARK.email — NOT NULL
  • id (id2) — LONG — Foreign key → Category.id — NOT NULL
  • restaurant_name — varchar(255)
  • text — CLOB
  • kakao_map_url — varchar(255)
  • grade — Double
  • created_at — DATETIME
  • updated_at — DATETIME
  • like_count (좋아요 수) — LONG

Pin_Images (Untitled6)

  • id — UUID — Primary key — NOT NULL
  • id (id2) — Long — Foreign key → Pin.id — NOT NULL
  • email — varchar(255) — Foreign key → Pin.email — NOT NULL
  • email (email2) — varchar(255) — Foreign key → Pin.email — NOT NULL
  • id (id22) — LONG — Foreign key → Pin.id — NOT NULL
  • imageUrl — VARCHAR(255)

TAG (Untitled2)

  • id — LONG — Primary key — NOT NULL
  • id (id2) — Long — Foreign key → PIN_TAG.id — NOT NULL
  • email — varchar(255) — Foreign key → PIN_TAG.email — NOT NULL
  • email (email2) — varchar(255) — Foreign key → PIN_TAG.email — NOT NULL
  • id (id22) — LONG — Foreign key → PIN_TAG.id — NOT NULL
  • name (태그명) — VARCHAR255

Users (사용자)

  • email — varchar(255) — Primary key — NOT NULL
  • password — varchar(255)
  • user_name (이름) — varchar(255)
  • role (역할) — varchar(255)
  • profile_imgae_url (프로필사진) — varchar(255)
  • created_at (생성일시) — TIMESTAMP