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