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