재구성 ERD 2
테이블 (21)
admin
- admin_id — VARCHAR(20) — 기본 키 — NOT NULL
- admin_token — VARCHAR(50) — 외래 키 → admin_signup.admin_token — NOT NULL
- admin_password_hash — VARCHAR(255)
admin_auth
- ref_token — VARCHAR(50) — 기본 키 — NOT NULL
- admin_id — VARCHAR(20) — 외래 키 → admin.admin_id — NOT NULL
- recent_token — VARCHAR(2000) — NOT NULL
- token_issued_time — INT
admin_signup
- admin_token — VARCHAR(50) — 기본 키 — NOT NULL
- admin_token_to — VARCHAR(20)
- admin_token_contents — VARCHAR(2000)
ban_users
- user_id — VARCHAR(20) — 외래 키 → users.user_id — NOT NULL
- ban_check — TINYINT
- ban_reason — VARCHAR(1000)
- ban_expiry_time — INT
edu_prog
- user_id — VARCHAR(20) — 외래 키 → users.user_id — NOT NULL
- contents_id — INT — 외래 키 → vr_contents.contents_id — NOT NULL
- user_name — VARCHAR(20)
- user_birth — VARCHAR(20)
- user_phone — VARCHAR(20)
- user_edu_prog — TINYINT
- check_complete_time — INT
employee_cert
- ref_token — VARCHAR(50) — 기본 키 — NOT NULL
- user_id — VARCHAR(20) — 외래 키 → users.user_id — NOT NULL
- recent_token — VARCHAR(2000) — NOT NULL
- token_issued_time — INT
game_default
- version — VARCHAR(20) — 기본 키 — NOT NULL
- seminar_max_person — INT
- banner_data — VARCHAR(50)
gold_data
- gold_id — INT — 기본 키 — NOT NULL
- date_time — INT
- price — DECIMAL(15,4)
komsco_world_data
- world_id — VARCHAR(20) — 외래 키 → world.world_id — NOT NULL
- scene — BLOB
- view — BLOB
- meta — BLOB
manage_auth
- admin_code — INT — 외래 키 → management.admin_code — NOT NULL
- admin_token — VARCHAR(50) — 외래 키 → admin_signup.admin_token — NOT NULL
management
- admin_code — INT — 기본 키 — NOT NULL
- admin_contents — VARCHAR(2000)
mobile_license_token
- license_key — VARCHAR(50) — 기본 키 — NOT NULL
- user_id — VARCHAR(20) — 외래 키 → users.user_id — NOT NULL
- recent_token — VARCHAR(2000) — NOT NULL
- token_issued_time — INT
multiple_quiz
- quiz_id — INT — 기본 키 — NOT NULL
- quiz_check — VARCHAR(20)
- count_correct — INT
- count_wrong — INT
multiple_quiz_content
- quiz_id — INT — 외래 키 → multiple_quiz.quiz_id — NOT NULL
- quiz_content_id — INT — 외래 키 → quiz_contents.quiz_content_id — NOT NULL
olot_display
- display_index — INT — 기본 키 — NOT NULL
- count_conversation — INT
- count_visit_start — INT
- count_visit_end — INT
quiz_contents
- quiz_content_id — INT — 기본 키 — NOT NULL
- quiz_contents — VARCHAR(2000)
statistics_data
- date_time — INT — 기본 키 — NOT NULL
- dau_count — INT
- mcu_count — INT
users
- user_id — VARCHAR(20) — 기본 키 — NOT NULL
- user_avatar_cache_data — VARCHAR(2000)
- user_profile_cache_data — VARCHAR(2000)
- user_option_cache_data — VARCHAR(2000)
- user_signup_time — INT
vr_contents
- contents_id — INT — 기본 키 — NOT NULL
- contents — VARCHAR(2000)
world
- world_id — VARCHAR(20) — 기본 키 — NOT NULL
- content — BLOB
world_auth
- world_id — VARCHAR(20) — 외래 키 → world.world_id — NOT NULL
- admin_token — VARCHAR(50) — 외래 키 → admin_signup.admin_token — NOT NULL