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)