Journimal
Tables (7)
Airport
- id — INT — Primary key — NOT NULL
- air_id — INT — Foreign key → Trip.id — NOT NULL
- airport_name — VARCHAR(50)
- country — VARCHAR(50)
- city — VARCHAR(50)
- code — VARCHAR(50)
Animal
- id — INT — Primary key — NOT NULL
- ani_id — INT — Foreign key → Trip.id — NOT NULL
- image — VARCHAR(255)
- name — VARCHAR(11)
- level — VARCHAR(30)
- status — VARCHAR(30)
Mission
- id — INT — Primary key — NOT NULL
- mission_id — INT — Foreign key → User_Missions.id — NOT NULL
- mission_name — VARCHAR(30)
- level — VARCHAR(11)
- thumbnail — VARCHAR(255)
- image — VARCHAR(255)
- description — VARCHAR(100)
Trip
- id — INT — Primary key — NOT NULL
- departure — VARCHAR(11)
- arrival — VARCHAR(11)
- animal_image_id — INT
- final_animal — INT
- first_day — DATETIME
- last_day — DATETIME
- complete_mission — INT
User
- id — INT — Primary key — NOT NULL
- user_mission_id — INT — Foreign key → User_Missions.id — NOT NULL
- user_id — VARCHAR(11)
- user_pw — VARCHAR(11)
- user_name — VARCHAR(11)
- trip_count — INT
- complete_mission — INT
User_Missions
- id — INT — Primary key — NOT NULL
- user_id — INT
- mission_id — INT
- completed — VARCHAR(30)
user_animal
- id — INT
- user_id — INT — NOT NULL
- animal_id — INT — NOT NULL
- count — INT
- UNIQUE(user_id, — animal_id)