ProjectDD

Tables (11)

CHARACTER (캐릭터)

  • CHARACTER_ID (캐릭터 고유번호) — Primary key — NOT NULL
  • NAME (이름)
  • COMMENT (설명)
  • AD (공격력)
  • DF (방어력)
  • SP (스피드)
  • HP (체력)
  • Type (타입)

COMPENSATION (처치 보상_재화)

  • GOODS_ID (재화 고유 번호) — Foreign key → GOODS.GOODS_ID — NOT NULL
  • CHARACTER_ID (캐릭터 고유번호) — Foreign key → CHARACTER.CHARACTER_ID — NOT NULL
  • MIN_VALUE (최소값)
  • MAX_VALUE (최대값)

COMPENSATION_ITEM (처치보상_아이템)

  • CHARACTER_ID (캐릭터 고유번호) — Foreign key → CHARACTER.CHARACTER_ID — NOT NULL
  • ITEM_ID (아이템 고유번호) — Foreign key → ITEM.ITEM_ID — NOT NULL
  • MIN_VALUE (최소값)
  • MAX_VALUE (최대값)

GOODS (재화 목록)

  • GOODS_ID (재화 고유 번호) — Primary key — NOT NULL
  • GOODS_NAME (재화 명)
  • MAX_VALUE (최대값)

ITEM (아이템)

  • ITEM_ID (아이템 고유번호) — Primary key — NOT NULL
  • NAME (아이템 명)
  • COMMENT (설명)
  • MAX_COUNT (최대값)

MC_SKILL (보유중인 캐릭터가 찍은 스킬)

  • MC_SKILL (Key) — Primary key — NOT NULL
  • MEM_CHR_ID (고유 아이디) — Foreign key → MEMBER_CHARACTER.MEM_CHR_ID — NOT NULL
  • SKILL_ID (스킬 고유번호) — Foreign key → SKILL.SKILL_ID — NOT NULL

MEMBER (회원)

  • MEMBER_ID (멤버 고유 번호) — Primary key — NOT NULL
  • LOGIN_ID (로그인 아이디)
  • PASS_WORD (비밀번호)
  • NICK_NAME (닉네임)
  • RANK (랭크 점수)

MEMBER_CHARACTER (보유중인 캐릭터)

  • MEM_CHR_ID (고유 아이디) — Primary key — NOT NULL
  • MEMBER_ID (멤버 고유 번호) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • CHARACTER_ID (캐릭터 고유번호) — Foreign key → CHARACTER.CHARACTER_ID — NOT NULL
  • LEVEL (캐릭터 레벨)

MEMBER_GOODS (회원 별 보유 재화)

  • MEMBER_ID (멤버 고유 번호) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • GOODS_ID (재화 고유 번호) — Foreign key → GOODS.GOODS_ID — NOT NULL
  • RESERVE (재화 보유량)
  • Field

MEMBER_ITEM (보유중인 아이템)

  • MEMBER_ID (멤버 고유 번호) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • ITEM_ID (아이템 고유번호) — Foreign key → ITEM.ITEM_ID — NOT NULL
  • COUNT (개수)
  • POSITION (인벤토리 위치)

SKILL (스킬)

  • SKILL_ID (스킬 고유번호) — Primary key — NOT NULL
  • CHARACTER_ID (캐릭터 고유번호) — Foreign key → CHARACTER.CHARACTER_ID — NOT NULL
  • SKILL_NAME (스킬명)
  • COMMENT (설명)
  • DEMEGA (기본데미지)
  • AD_COEFF (공격력계수)
  • DF_COEFF (방어력계수)
  • HP_COEFF (체력계수)
  • ACT_TIME (공격시간)
  • Field (회피타이밍)
  • Field (가드타이밍)
  • Field (점프타이밍)
  • Field (회피가능여부)
  • Field (가드가능여부)
  • Field (점프가능여부)