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