toystory
Tables (8)
class (USERS)
- id (Key) — INT — Primary key — NOT NULL
- email (Field) — STRING
- nickname (Field2) — STRING
class (COMMENTS)
- id (Key) — INT — Primary key — NOT NULL
- post_id (Field) — INT
- content (Field3) — STRING
- created_at (Field4) — Timestamp with timezone
- updated_at (Field5) — Timestamp with timezone
- deleted_at (Field6) — Timestamp with timezone
- id (user_id) — INT — Foreign key → class.id — NOT NULL
- id (post_id) — INT — Foreign key → class.id — NOT NULL
class (POSTS)
- id — INT — Primary key — NOT NULL
- id (travel_information_id) — INT — Foreign key → interface.id — NOT NULL
class (RESTAURANT)
- id (Key) — INT — Primary key — NOT NULL
- certification (Field) — ENUM
- is_alcohol_exist (Field2) — BOOLEAN
class (MENU)
- id — Primary key — NOT NULL
- menu — STRING
- price — INT
- id (restaurant_id) — INT — Foreign key → class.id — NOT NULL
class (Prayer Room)
- id (Key) — INT — Primary key — NOT NULL
- is_book_exist (Field) — BOOLEAN
- gender_sep (Field2) — BOOLEAN
class (Attraction Site)
- id (Key) — INT — Primary key — NOT NULL
- visit_fee — INT
interface (TRAVEL_INFORMATION)
- id — INT — Primary key — NOT NULL
- name — STRING
- address — STRING
- contact — STRING
- homepage — STRING
- parking — BOOLEAN
- created_at — TIMESTAMP_WITH_TIMEZONE
- updated_at — TIMESTAMP_WITH_TIMEZONE
- deleted_at — TIMESTAMP_WITH_TIMEZONE