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