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