gstagram

Tables (18)

Untitled (city_favorite)

  • id (user_id) — VARCHAR(32) — Foreign key → user.id — NOT NULL
  • Key (city_id) — INT — Foreign key → Untitled.Key — NOT NULL

Untitled (course_tag)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (tag_name) — VARCHAR(25)

Untitled (region_course_article_tag)

  • id (course_id) — INT — Foreign key → course.id — NOT NULL
  • Key (tag_id) — INT — Foreign key → Untitled.Key — NOT NULL

Untitled (booklet)

  • Key (id) — INT — Primary key — NOT NULL
  • id (region_id) — INT — Foreign key → region.id — NOT NULL

Untitled (booklet_caption)

  • Key (id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (s3_url) — VARCHAR(255)
  • Field (caption) — VARCHAR(255)
  • Field (sequence) — INT

Untitled (region_course_article_scrap)

  • Key (id) — INT — Primary key — NOT NULL
  • id (user_id) — VARCHAR(32) — Foreign key → user.id — NOT NULL
  • Field (scrap_date) — DATETIME
  • id (course_id) — INT — Foreign key → course.id — NOT NULL

Untitled (user_streak)

  • id (uuid) — VARCHAR(32) — Foreign key → user.id — NOT NULL
  • Field (last_connect) — DATETIME

Untitled (city)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (city_name) — VARCHAR(8)
  • id (region_id) — INT — Foreign key → region.id — NOT NULL

Untitled (course_like)

  • id (course_id) — INT — Foreign key → course.id — NOT NULL
  • id (user_id) — VARCHAR(32) — Foreign key → user.id — NOT NULL
  • Field (created_date) — DATETIME

Untitled (course_comment)

  • Key (id) — INT — Primary key — NOT NULL
  • id (course_id) — INT — Foreign key → course.id — NOT NULL
  • id (uuid) — VARCHAR(32) — Foreign key → user.id — NOT NULL
  • Field (content) — VARCHAR(255)
  • Field (created_date) — DATETIME

Untitled (place_image)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (image_url) — VARCHAR(255)
  • id (place_id) — INT — Foreign key → place.id — NOT NULL

Untitled (badge)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (badge_image) — VARCHAR(255)
  • Field (description) — VARCHAR(255)
  • Field (badge_title) — VARCHAR(255)

Untitled (user_badge)

  • id (user_id) — VARCHAR(32) — Foreign key → user.id — NOT NULL
  • Key (badge_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (get_date) — DATETIME

course

  • id — INT — Primary key — NOT NULL
  • course_name — VARCHAR(255)
  • description — VARCHAR(255)
  • id (user_id) — VARCHAR(32) — Foreign key → user.id — NOT NULL
  • Key (city_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • id (region_id) — INT — Foreign key → region.id — NOT NULL
  • Field (thumbnail_url) — VARCHAR(255)
  • Field (view_count) — INT

place

  • id — INT — Primary key — NOT NULL
  • place_name — VARCHAR(30)
  • description — VARCHAR(255)
  • latitude — DECIMAL
  • longitude — DECIMAL
  • id (course_id) — INT — Foreign key → course.id — NOT NULL
  • Field (sequence) — INT

region

  • id — INT — Primary key — NOT NULL
  • region_name — VARCHAR(8)
  • user_count — INT

user

  • id (uuid) — VARCHAR(32) — Primary key — NOT NULL
  • email — VARCHAR(32)
  • password — VARCHAR(32)
  • username — VARCHAR(6)
  • nickname — VARCHAR(12)
  • is_user_authorized — TINYINT
  • profile_image_url (profile_image_s3_url) — VARCHAR(255)

user_region (user_city)

  • id (uuid) — VARCHAR(32) — Foreign key → user.id — NOT NULL
  • Key (city_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • region_register_date — DATETIME