D211

Tables (5)

Member (사용자)

  • member_id (사용자id) — int — Primary key — NOT NULL
  • email (이메일) — varchar(255) — NOT NULL
  • nickname (닉네임) — varchar(12) — NOT NULL
  • password (비밀번호) — varchar — NOT NULL
  • gacha (가챠권 개수) — int — NOT NULL
  • current_class_no (장착 중인 클래스) — int — NOT NULL
  • today_lock_time (오늘 방치 시간) — int — NOT NULL
  • yesterday_lock_time (어제 방치 시간) — int — NOT NULL
  • total_lock_time (누적 방치 시간) — int — NOT NULL
  • continuous_lock_date (연속 방치일 수) — int — NOT NULL
  • continuous_lock_date_prev (연속 방치일 수 (어제까지)) — int — NOT NULL
  • last_lock_date (마지막 방치일) — date
  • withdrawal_yn (탈퇴여부) — tinyint — NOT NULL
  • created_date (가입일) — date — NOT NULL
  • lock_yn (방치 on/off) — tinyint — NOT NULL

Member_Relic (사용자_유물)

  • member_relic_id (사용자_유물id) — int — Primary key — NOT NULL
  • member_id (사용자id) — int — Foreign key → Member.member_id — NOT NULL
  • relic_no (유물고유번호) — int — NOT NULL
  • level (유물레벨) — int — NOT NULL
  • exp (유물경험치량) — int — NOT NULL
  • slot (장착슬롯) — int — NOT NULL

Record (기록)

  • record_id (기록 id) — int — Primary key — NOT NULL
  • member_id (사용자id) — int — Foreign key → Member.member_id — NOT NULL
  • stage (스테이지) — int — NOT NULL
  • difficulty (난이도) — int — NOT NULL
  • elite_kill (엘리트몹킬수) — int — NOT NULL
  • normal_kill (일반몹킬수) — int — NOT NULL
  • class_no (클래스고유번호) — int — NOT NULL
  • updated_date (경신일) — date — NOT NULL

Record_Relic (기록_유물)

  • record_id (기록id) — int — Foreign key → Record.record_id — NOT NULL
  • relic_no (유물고유번호) — int — NOT NULL
  • level (당시유물레벨) — int — NOT NULL
  • slot (당시장착슬롯) — int — NOT NULL

Record_Skill (기록_스킬)

  • record_id (기록id) — int — Foreign key → Record.record_id — NOT NULL
  • skill_no (스킬고유번호) — int — NOT NULL
  • level (당시스킬레벨) — int — NOT NULL
  • slot (당시장착슬롯) — int — NOT NULL