K-HTML
Tables (5)
feedbacks
- feedback_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.id
- walktrail_id — INT — Foreign key → walk_trails.id
- location — TEXT
- type — VARCHAR(20)
- category — VARCHAR(20)
- latitude — FLOAT
- longitude — FLOAT
- feedback_content — TEXT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- feedback_image — TEXT
- status — ENUM( 'in_progress', 'completed', 'rejected')
response (Untitled)
- feedback_id — INT — Foreign key → feedbacks.feedback_id — NOT NULL
- response_content — TEXT
- response_image — TEXT
- responsed_at — DATETIME
routes
- trail_id — INT — Foreign key → walk_trails.id
- latitude — FLOAT
- longitude — FLOAT
users
- id — INT — Primary key
- email — VARCHAR(100) — NOT NULL
- username — VARCHAR(50)
- password — VARCHAR(20)
- nickname — VARCHAR(50)
- created_at — DATETIME
- is_admin — BOOLEAN
walk_trails
- id — INT — Primary key
- name — VARCHAR(100) — NOT NULL
- time — VARCHAR(20)
- distance — VARCHAR(20)
- route_description — TEXT
- created_at — DATETIME