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