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)