lotto

Tables (5)

generator

  • id — long — Primary key — NOT NULL
  • round (round_id) — long — Foreign key → round.id — NOT NULL
  • no1 (drw_no1) — int
  • no2 (drw_no2) — int
  • no3 (drw_no3) — int
  • no4 (drw_no4) — int
  • no5 (drw_no5) — int
  • no6 (drw_no6) — int
  • createDate (create_date) — date
  • createBy (create_by) — string
  • rank — int

member (Untitled3)

  • id — Long — Primary key — NOT NULL
  • member_id — string
  • password — string
  • email — string

round

  • id (round_id) — long — Primary key — NOT NULL
  • no1 (drw_no1) — int
  • no2 (drw_no2) — int
  • no3 (drw_no3) — int
  • no4 (drw_no4) — int
  • no5 (drw_no5) — int
  • no6 (drw_no6) — int
  • bonus (drw_bonus) — int
  • createDate (create_date) — date

store (Untitled2)

  • id — int — Primary key — NOT NULL
  • round (round_id) — long — Foreign key → round.id — NOT NULL
  • name — string
  • autoyn — bool
  • address — string
  • mapUrl (map_url) — string

win_info (Untitled)

  • id — int — Primary key — NOT NULL
  • rank — int — Primary key
  • round (round_id) — long — Foreign key → round.id — NOT NULL
  • amount — long
  • win_conut (win_count) — long