분배금 계산기
테이블 (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