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