재구성 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