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