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