week6_miniproject
Tables (12)
ConterComment (카운트게임 댓글기능)
- Id (Key) — Long — Primary key — NOT NULL
- content (Field) — String
- id (Key2) — String — Foreign key → Member.id — NOT NULL
CounterResult (멤버별 카운트게임 결과)
- Id (Key) — Long — Primary key — NOT NULL
- maxCount (Field) — int
- playCount (Field2) — int
- earnPoint (Field3) — int
- id (Key2) — String — Foreign key → Member.id — NOT NULL
DiceComment (주사위게임 댓글기능)
- Id (Key) — Long — Primary key — NOT NULL
- content (Field) — String
- id (Key2) — String — Foreign key → Member.id — NOT NULL
DiceResult (멤버별 주사위게임 결과)
- Id (Key) — Long — Primary key — NOT NULL
- winCount (Field) — int
- playCount (Field2) — int
- earnPoint (Field3) — int
- id (Key2) — String — Foreign key → Member.id — NOT NULL
ImageMapper (사진 관리용 Table)
- Id (Key) — Long — Primary key — NOT NULL
- imageName (Field) — String
- url (Field2) — String
Lotto (로또 구매 영수증)
- id (Key) — Long — Primary key — NOT NULL
- num1 (Field) — int
- num2 (Field2) — int
- num3 (Field3) — int
- num4 (Field4) — int
- num5 (Field5) — int
- num6 (Field6) — int
- id (Key2) — String — Foreign key → Member.id — NOT NULL
- id (Key3) — Long — Foreign key → LottoServer.id — NOT NULL
LottoComment (로또 댓글기능)
- Id (Key) — Long — Primary key — NOT NULL
- content (Field) — String
- id (Key2) — String — Foreign key → Member.id — NOT NULL
LottoCount (멤버별 로또 결과)
- Id (Key) — Long — Primary key — NOT NULL
- count1st (Field) — int
- count2nd (Field2) — int
- count3rd (Field3) — int
- count4th (Field4) — int
- count5th (Field5) — int
- playCount (Field6) — int
- earnPoint (Field7) — int
- id (Key2) — String — Foreign key → Member.id — NOT NULL
LottoServer (로또 서버)
- id (Key) — Long — Primary key — NOT NULL
- luckynum1 (Field) — int
- luckyNum2 (Field2) — int
- luckyNum3 (Field3) — int
- luckyNucky (Field4) — int
- luckyNum5 (Field5) — int
- luckyNum6 (Field6) — int
- point1st (Field7) — int
- point2nd (Field8) — int
- point3rd (Field9) — int
- point (Field10) — int
Member (Untitled)
- id (Key) — String — Primary key — NOT NULL
- passWord (Field) — String
- nickName (Field2) — String
- img (Field3) — String
- birthDate (Field4) — String
- point (Field5) — int
- userRole (Field6)
OddEvenComment (홀짝게임 댓글기능)
- Id (Key) — Long — Primary key — NOT NULL
- content (Field) — String
- id (Key2) — String — Foreign key → Member.id — NOT NULL
OddEvenResult (멤버별 홀짝게임 결과)
- Id (Key) — Long — Primary key — NOT NULL
- winCount (Field) — int
- playCount (Field2) — int
- earnPoint (Field3) — int
- id (Key2) — String — Foreign key → Member.id — NOT NULL