분배금 계산기

테이블 (6)

BossCube (Untitled4)

  • bossCubeId (Key) — Long — 기본 키 — NOT NULL
  • bossName (Field) — String
  • cubeCount (Field2) — Integer
  • item (Field3) — Item

Item (Untitled)

  • itmeId (Key) — Long — 기본 키 — NOT NULL
  • itemName (Field) — String
  • price (Field2) — Double
  • count (Field3) — Integer
  • settlementId (Key2) — Long — 외래 키 → Settlement.settlementId — NOT NULL
  • bossCubeId (Key3) — Long — 외래 키 → BossCube.bossCubeId — NOT NULL

Member (user)

  • memberId (Key) — Long — 기본 키 — NOT NULL
  • membername (Field) — String
  • password (Field2) — String
  • loginType (Field3) — LoginType

Party (party)

  • partyId (Key) — Long — 기본 키 — NOT NULL
  • partyName (Field) — String
  • password (Field2) — String
  • Leader (Field3) — User
  • commissionRate (Field4) — Double

PartyMember (Untitled5)

  • id (Key) — Long — 기본 키 — NOT NULL
  • member (Field) — User
  • party (Field2) — Party
  • distributionRate (Field3) — Double
  • partyId (Key2) — Long — 외래 키 → Party.partyId — NOT NULL
  • memberId (Key3) — Long — 외래 키 → Member.memberId — NOT NULL

Settlement (Untitled6)

  • settlementId (Key) — Long — 기본 키 — NOT NULL
  • party (Field) — Party
  • totalAmount (Field2) — Double
  • commissionRate (Field3) — CommissionRate
  • items (Field4) — Integer
  • partyID (Key2) — Long — 외래 키 → Party.partyId — NOT NULL