mitchinmat v2

Tables (6)

comment

  • id — bigint — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • content — varchar(255)
  • place_id — bigint — Foreign key → place.id
  • user_id — bigint — Foreign key → user.id
  • id (id2) — bigint — Foreign key → user.id — NOT NULL

friend

  • id — bigint — Primary key — NOT NULL
  • user_id1 — bigint
  • user_id2 — bigint — Foreign key → user.id
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • view_status — tinyint(1)
  • id (id22) — bigint — Foreign key → user.id — NOT NULL

friend_of_friend

  • user_id — bigint — Primary key — NOT NULL
  • friend_id_list — varchar(255)
  • created_date — datetime(6)
  • modified_date — datetime(6)

good_place

  • user_id — bigint — Foreign key → user.id — NOT NULL
  • place_id — bigint — Foreign key → place.id — NOT NULL
  • id (id2) — bigint — Foreign key → user.id — NOT NULL
  • custom_tag — varchar(255)
  • memo — varchar(255)
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • public_status — bit(1) — NOT NULL

place

  • id — bigint — Primary key — NOT NULL
  • x — double
  • y — double
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • address_name — varchar(255)
  • phone — varchar(255)
  • place_name — varchar(255)
  • place_url — varchar(255)
  • road_address_name — varchar(255)
  • road_find_url — varchar(255)
  • search_url — varchar(255)
  • image_url — varchar(255)
  • operation_time — varchar(255)
  • tags — varchar(255)
  • total_kakao_reviews — int
  • kakao_review_score — double
  • cate_name_1 (cate_nm_1) — varchar(255)
  • cate_name_2 (cate_nm_2) — varchar(255)
  • cate_name_3 (cate_nm_3) — varchar(255)
  • cate_name_4 (cate_nm_4) — varchar(255)
  • cate_name_5 (cate_nm_5) — varchar(255)

user

  • id — bigint — Primary key — NOT NULL
  • id (id2) — bigint — Foreign key → friend.id — NOT NULL
  • created_date — datetime(6)
  • good_place_count — bigint
  • inactive_date — datetime(6)
  • modified_date — datetime(6)
  • user_id — bigint — Foreign key → friend_of_friend.user_id
  • oauth2id — varchar(255)
  • profile_image — varchar(255)
  • username — varchar(255)
  • provider — enum('KAKAO') — NOT NULL
  • role — enum('ADMIN','USER','ANONYMOUS')
  • status — enum('ACTIVE','INACTIVE') — NOT NULL