project1

Tables (6)

Accounts (Untitled6)

  • Account No (account_no) — number(6) — Primary key — NOT NULL
  • User No (user_no2) — number(6) — Foreign key → Users.User No — NOT NULL
  • Balance (balance) — number(11,0)
  • Created At (created_at) — date

Game Bets (Untitled3)

  • Bet No (bet_no) — number(6) — Primary key — NOT NULL
  • User No (user_no2) — number(6) — Foreign key → Users.User No — NOT NULL
  • Game No (game_no2) — number(6) — Foreign key → Games.Game No — NOT NULL
  • Bet Point (bet_point) — number(11,0)
  • Odds (odds) — number(5,2)
  • User Choice (user_choice) — varchar2(10)
  • Game Result (game_result) — number(1)
  • Win (win) — number(1)
  • Payout (payout) — number(11,0)
  • Created At (created_at) — date

Games (Untitled2)

  • Game No (game_no) — number(6) — Primary key — NOT NULL
  • Game Name (game_name) — varchar2(30)
  • Description (description) — varchar2(1000)
  • Base Rate (base_rate) — number(5,2)
  • Is Active (is_active) — number(1)
  • Created At (created_at) — date

Point History (Untitled5)

  • History No (history_no) — number(6) — Primary key — NOT NULL
  • User No (user_no2) — number(6) — Foreign key → Users.User No — NOT NULL
  • Type (type) — varchar2(20)
  • Amount (amount) — number(11,0)
  • Balance After (balance_after) — number(11,0)
  • Ref Table (ref_table) — varchar2(20)
  • Ref No (ref_no) — number(6)
  • Created At (created_at) — date

Point Requests (Untitled4)

  • Requeset No (request_no) — number(6) — Primary key — NOT NULL
  • User No (user_no2) — number(6) — Foreign key → Users.User No — NOT NULL
  • Type (Field) — varchar2(10)
  • Amount (amount) — number(11,0)
  • Status (status) — varchar2(10)
  • Created At (created_at) — date
  • Processed At (processed_at) — date

Users (Untitled)

  • User No (user_no) — number(6) — Primary key — NOT NULL
  • User ID (user_id) — varchar2(15)
  • User PW (user_pw) — varchar2(255)
  • Role (role) — varchar2(10)
  • Point (point) — number(11,0)
  • Created At (created_at) — date