project

Tables (19)

Club (club)

  • Id (id) — VARCHAR — Primary key — NOT NULL — 클럽 이름
  • School_Id (school_id) — VARCHAR — Foreign key → School.Id — NOT NULL — 학교 이름

EX_Skill (ex_skill)

  • Id (id) — VARCHAR — Primary key — NOT NULL — EX 스킬 이름
  • Student_Id (student_id) — VARCHAR — Foreign key → Student.Id — NOT NULL — 학생 이름

EX_Skill_Info (ex_skill_info)

  • Ex_Level (ex_level) — INTEGER — Primary key
  • Ex_Skill_Id (ex_skill_id) — VARCHAR — Foreign key → EX_Skill.Id — NOT NULL — EX 스킬 이름
  • Ex_Cost (ex_cost) — INTEGER
  • Ex_Description (ex_description) — VARCHAR

Equipment (equipment)

  • Id (id) — VARCHAR — Primary key — 장비 이름
  • Equipment_Type (equipment_type) — VARCHAR — 장비 타입
  • Equipment_Tier (equipment_tier) — VARCHAR — 장비 티어
  • Description (description) — VARCHAR
  • Status1 (status1) — VARCHAR
  • Status2 (status2) — VARCHAR
  • Status3 (status3) — VARCHAR
  • Status4 (status4) — VARCHAR

Ex_Spend (ex_spend)

  • Level (level) — INTEGER — Primary key
  • Item_id (item_id) — VARCHAR — Foreign key → Item.Id — 아이템 이름
  • Student_Id (student_id) — VARCHAR — Foreign key → Student.Id — NOT NULL — 학생 이름
  • Quantity (quantity) — INTEGER

Favorite_Equipment (favorite_equipment)

  • Id (id) — VARCHAR — Primary key — NOT NULL — 애장품 이름
  • Student_Id (student_id) — VARCHAR — Foreign key → Student.Id — NOT NULL — 학생 이름
  • Description (description) — VARCHAR

Favorite_Equipment_Info (favorite_equipment_info)

  • Equipment_Tier (equipment_tier) — INTEGER — Primary key
  • Favorite_Equipment_Id (favorite_equipment_id) — VARCHAR — Foreign key → Favorite_Equipment.Id — NOT NULL — 애장품 이름
  • Effect (effect) — VARCHAR

Item (item)

  • Id (id) — VARCHAR — Primary key — 아이템 이름
  • Item_Rank (item_rank) — INTEGER
  • Item_Type (item_type) — VARCHAR

School (school)

  • Id (id) — VARCHAR — Primary key — NOT NULL — 학교 이름

Skill (skill)

  • Id (id) — VARCHAR — Primary key — NOT NULL — 스킬 이름
  • Student_Id (student_id) — VARCHAR — Foreign key → Student.Id — NOT NULL — 학생 이름

Skill_Info (skill_info)

  • Skill_Level (skill_level) — INTEGER — Primary key
  • Skill_Id (skill_id) — VARCHAR — Foreign key → Skill.Id — NOT NULL — 스킬 이름
  • Skill_Description (skill_description) — VARCHAR

Skill_Spend (skill_spend)

  • Level (level) — INTEGER — Primary key
  • Item_id (item_id) — VARCHAR — Foreign key → Item.Id — 아이템 이름
  • Student_Id (student_id) — VARCHAR — Foreign key → Student.Id — NOT NULL — 학생 이름
  • Quantity (quantity) — INTEGER

Student (student)

  • Id (id) — VARCHAR — Primary key — NOT NULL — 학생 이름
  • Club_Id (club_id) — VARCHAR — Foreign key → Club.Id — NOT NULL — 클럽 이름
  • School_Id (school_id) — VARCHAR — Foreign key → Club.School_Id — NOT NULL — 학교 이름

Student_Equipment (student_equipment)

  • Student_Id (student_id) — VARCHAR — Foreign key → Student.Id — NOT NULL — 학생 이름
  • Equipment_Id (equipment_id) — VARCHAR — Foreign key → Equipment.Id — 장비 이름

Student_Profile (student_profile)

  • Student_Id (student_id) — VARCHAR — Foreign key → Student.Id — NOT NULL — 학생 이름
  • Club_Id (club_id) — VARCHAR — Foreign key → Student.Club_Id — NOT NULL — 클럽 이름
  • School_Id (school_id) — VARCHAR — Foreign key → Student.School_Id — NOT NULL — 학교 이름
  • Full_Name (full_name) — VARCHAR — 학생 전체 이름
  • Armor_Type (armor_type) — VARCHAR — 방어타입
  • Attack_Type (attack_type) — VARCHAR — 공격 타입
  • Student_Role (student_role) — VARCHAR — 학생 역할(딜러, 서포터, 탱커)
  • Student_Position (student_position) — VARCHAR — 학생위치
  • Student_Type (student_type) — VARCHAR — 학생 타입 - Striker, Special
  • Adaptability_City (adaptability_city) — VARCHAR
  • Adaptability_field (adaptability_field) — VARCHAR
  • Adaptability_Inside (adaptability_Inside) — VARCHAR

Student_Status (student_status)

  • Student_Id (student_id) — VARCHAR — Foreign key → Student.Id — NOT NULL — 학생 이름
  • HP (hp) — INTEGER
  • ATK (atk) — INTEGER
  • Armor (armor) — INTEGER
  • HealingPower (healing_power) — INTEGER
  • Evasion (evasion) — INTEGER
  • CriticalRate (critical_rate) — INTEGER
  • CriticalDamageRate (critical_damage_ratio) — INTEGER
  • Stability (stability) — INTEGER
  • ShootingRange (range) — INTEGER
  • CC-Enhancement (cc_enhance) — INTEGER
  • CC-Resistance (cc_resistance) — INTEGER
  • Cost-Recovery (cost_recovery) — INTEGER

Unique_Weapon (unique_weapon)

  • Id (id) — VARCHAR — Primary key — NOT NULL — 고유무기 이름
  • Student_Id (student_id) — VARCHAR — Foreign key → Student.Id — NOT NULL — 학생 이름
  • Description (description) — VARCHAR
  • Weapon_Type (weapon_type) — VARCHAR

Unique_Weapon_Info (unique_weapon_info)

  • Unique_Weapon_Id (unique_weapon_id) — VARCHAR — Foreign key → Unique_Weapon.Id — NOT NULL — 고유무기 이름
  • Student_Id (student_id) — VARCHAR — Foreign key → Unique_Weapon.Student_Id — NOT NULL — 학생 이름
  • Star (star) — INTEGER
  • Effect (effect) — VARCHAR

Unique_Weapon_Status (unique_weapon_status)

  • Id (id) — INTEGER — Primary key — NOT NULL — 고유무기 레벨
  • Weapon_Name (weapon_name) — VARCHAR — Foreign key → Unique_Weapon.Id — NOT NULL
  • Student_Id (student_id) — VARCHAR — Foreign key → Unique_Weapon.Student_Id — NOT NULL — 학생 이름
  • Bonus_Atk (bonus_atk) — INTEGER
  • Bonus_Hp (bonus_hp) — INTEGER
  • Bonus_Healing_Power (bonus_healing_power) — INTEGER