dsfas
Tables (14)
categories
- category_id — INT
- large_category — VARCHAR(50) — NOT NULL
- middle_category — VARCHAR(50)
- small_category — VARCHAR(50)
course_editors
- editor_id — INT
- course_id — INT — NOT NULL
- user_id — INT — NOT NULL
course_spots
- course_spot_id — INT
- course_id — INT — NOT NULL
- spot_id — INT — NOT NULL
- order — INT — NOT NULL
course_tags
- course_tag_id — INT
- course_id — INT — NOT NULL
- tag_id — INT — NOT NULL
courses
- course_id — INT
- user_id — INT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- is_public — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
favorites
- favorite_id — INT
- user_id — INT — NOT NULL
- spot_id — INT — NOT NULL
- created_at — TIMESTAMP
regions
- region_id — INT
- city — VARCHAR(50) — NOT NULL
- district — VARCHAR(50)
- spot_id — INT
reviews
- review_id — INT
- user_id — INT — NOT NULL
- spot_id — INT — NOT NULL
- content — TEXT — NOT NULL
- rating — TINYINT
- created_at — TIMESTAMP
spot_images
- image_id — INT
- spot_id — INT — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
- description — VARCHAR(255)
- created_at — TIMESTAMP
spot_tags
- spot_tag_id — INT
- spot_id — INT — NOT NULL
- tag_id — INT — NOT NULL
spots
- spot_id — INT
- name — VARCHAR(255) — NOT NULL
- overview — TEXT
- contact — VARCHAR(50)
- latitude — DECIMAL(10, 7)
- longitude — DECIMAL(10, 7)
- address — VARCHAR(255)
- homepage_url — VARCHAR(255)
- category_id — INT
- created_at — TIMESTAMP
tags
- tag_id — INT
- tag_name — VARCHAR(50) — NOT NULL
user_tags
- user_tag_id — INT
- user_id — INT — NOT NULL
- tag_id — INT — NOT NULL
users
- user_id — INT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP