travel-erd

Tables (6)

categories

  • Key (id) — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • createdAt (created_at) — TIMESTAMP — NOT NULL
  • updatedAt (updated_at) — TIMESTAMP

cities

  • Key (id) — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • Key (province_id) — BIGINT — Foreign key → provinces.Key — NOT NULL
  • Field (created_at) — TIMESTAMP — NOT NULL
  • Field2 (updated_at) — TIMESTAMP

images

  • Key (id) — Primary key — NOT NULL
  • fileKey (file_key) — VARCHAR(255) — NOT NULL
  • Field (type) — VARCHAR(255) — NOT NULL
  • createdAt (created_at) — TIMESTAMP — NOT NULL
  • updatedAt (updated_at) — TIMESTAMP

places

  • Key (id) — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • latitude — DOUBLE — NOT NULL
  • longitude — DOUBLE — NOT NULL
  • overview — TEXT — NOT NULL
  • details — TEXT
  • createdAt (created_at) — TIMESTAMP — NOT NULL
  • updatedAt (updated_at) — TIMESTAMP
  • Field (view_count) — BIGTINT — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → users.Key — NOT NULL
  • Key (city_id) — BIGINT — Foreign key → cities.Key — NOT NULL
  • Key (category_id) — BIGINT — Foreign key → categories.Key — NOT NULL
  • Key2 (image_id) — BIGINT — Foreign key → images.Key
  • Key (province_id) — BIGINT — Foreign key → provinces.Key — NOT NULL

provinces

  • Key (id) — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • Field (created_at) — TIMESTAMP — NOT NULL
  • Field2 (updated_at) — TIMESTAMP

users

  • Key (id) — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • createdAt (created_at) — TIMESTAMP — NOT NULL
  • updatedAt (updated_at) — TIMESTAMP