LoZZANG

Tables (3)

Character (캐릭터)

  • id (고유번호) — BIGINT — Primary key — NOT NULL
  • expedition_id (원정대고유번호) — BIGINT — Foreign key → Expedition.id — NOT NULL
  • character_name (캐릭터이름) — varchar(20) — NOT NULL
  • class (클래스이름) — ENUM() — NOT NULL
  • level (템레벨) — DOUBLE — NOT NULL
  • created_at (생성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME — NOT NULL
  • is_use (사용야부) — BOOLEAN — NOT NULL

Expedition (원정대)

  • id (고유번호) — BIGINT — Primary key — NOT NULL
  • created_at (생성일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME — NOT NULL
  • character_id (최고레벨캐릭터id) — BIGINT — NOT NULL

LevelGoldMapping (레벨별 골드 획득량)

  • id (고유번호) — BIGINT — Primary key — NOT NULL
  • Min_level (최소레벨) — DOUBLE — NOT NULL
  • Max_level (최대레벨) — DOUBLE — NOT NULL
  • Gold_amount (골드량) — BIGINT — NOT NULL