lostarkweberd

Tables (6)

character (Untitled)

  • character_name — varchar — Primary key — NOT NULL
  • id (id2) — varchar — Foreign key → user.id — NOT NULL
  • character_name_represent (Field) — varchar
  • item_max_level (Field2) — float8
  • class_name (Field3) — varchar
  • class_type (Field4) — int

character_raid (레이드약속 디비)

  • no — int — Primary key — NOT NULL
  • character_name (character_name3) — varchar — Foreign key → character.character_name — NOT NULL
  • raid_name — varchar — Foreign key → raid.raid_name — NOT NULL
  • id — varchar
  • time — date
  • text — varchar

character_raid_detail (레이드에 속한 캐릭터 디비)

  • no — int — Foreign key → character_raid.no — NOT NULL
  • character_name — varchar — Foreign key → character.character_name — NOT NULL

raid (레이드)

  • raid_name — varchar — Primary key — NOT NULL
  • gold1 — int
  • gold2 — int
  • gold3 — int
  • reward1 — varchar
  • reward2 — varchar
  • reward3 — varchar
  • plus1 — varchar
  • plus2 — varchar
  • plus3 — varchar

user (서버로그인)

  • id — varchar — Primary key — NOT NULL
  • password — varchar

weekly_raid_result (주간 레이드 결산표)

  • character_name — varchar — Foreign key → character.character_name — NOT NULL
  • id — varchar — Foreign key → character.character_name — NOT NULL
  • karmen — boolean
  • ehidna (echidna) — boolean
  • behimoth — boolean
  • karmen4 — boolean
  • egir — boolean
  • abrellshould — boolean
  • chaos — boolean
  • guardian — boolean
  • epona — boolean
  • guildexchange — boolean