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