triperd

Tables (6)

USER

  • user_id — INTEGER — Primary key — NOT NULL
  • Field (name) — VARCHAR(255)
  • Field2 (region) — VARCHAR(255)
  • Field2 (birthday) — VARCHAR(255)
  • Field (gender) — VARCHAR(255)

Untitled (LIKE)

  • Key (like_id) — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → USER.user_id — NOT NULL
  • Field (like) — VARCHAR(255)
  • Field (priority) — VARCHAR(255)

Untitled (DISLIKE)

  • Key (dislike_id) — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → USER.user_id — NOT NULL
  • Field (dislike) — VARCHAR(255)

Untitled (SPORT)

  • Key (sport_id) — INTEGER — Primary key — NOT NULL
  • Field (name) — VARCHAR(255)
  • Field (materials) — TEXT
  • Field (environment_type) — VARCHAR(255)

Untitled (FESTIVAL)

  • Key (festival_id) — INTEGER — Primary key — NOT NULL
  • Field (festival_name) — VARCHAR(255)
  • Field (location) — VARCHAR(255)
  • Field (start_date) — DATE
  • Field (end_date) — DATE
  • Field (description) — TEXT
  • Field (organizing_agency) — VARCHAR(255)
  • Field (hosting_agency) — VARCHAR(255)
  • Field (sponsoring_agency) — VARCHAR(255)
  • Field (phone_number) — VARCHAR(50)
  • Field (website_url) — TEXT
  • Field (related_info) — TEXT
  • Field (road_address) — VARCHAR(255)
  • Field (lot_address) — VARCHAR(255)
  • Field (latitude) — DECIMAL(10, 7)
  • Field (longitude) — DECIMAL(10, 7)
  • Field (data_reference_date) — DATE
  • Field (provider_code) — VARCHAR(50)
  • Field (provider_name) — VARCHAR(255)

Untitled