Mitchinmat
Tables (9)
comment (댓글)
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- place_id — BIGINT — Foreign key → place.id — NOT NULL
- content — VARCHAR(255)
friend (친구)
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- friend_id — BIGINT — NOT NULL
friend_of_friend (모든 친구)
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- friend_id_list — VARCHAR(255)
good_place (맛집)
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- place_id — BIGINT — Foreign key → place.id — NOT NULL
- memo — TEXT
- custom_tag — VARCHAR(255)
place (음식점)
- id (place_id) — BIGINT — Primary key — NOT NULL
- place_name — VARCHAR(255)
- address_name — VARCHAR(255)
- road_address_name — VARCHAR(255)
- phone_number — VARCHAR(20)
- place_image_url — VARCHAR(255)
- x — DOUBLE
- y — DOUBLE
place_URL (음식점 url)
- place_id — BIGINT — Foreign key → place.id — NOT NULL
- place_url — VARCHAR(255)
- search_url — VARCHAR(255)
- load_find_url — VARCHAR(255)
place_category (음식점 카테고리)
- place_id — BIGINT — Foreign key → place.id — NOT NULL
- level — INT
- name — VARCHAR(10)
user (사용자)
- id (user_id) — BIGINT — Primary key — NOT NULL
- oauth2_id — VARCHAR(255)
- role — ENUM
- provider — ENUM
- username — VARCHAR(10)
- profile_image — VARCHAR(255)
- good_place_count — BIGINT
- inactive_date — DATE
- status (staus) — ENUM