TRADING
Tables (11)
ACCOUNT
- ID — INT — NOT NULL
- USER_ID — INT — NOT NULL
- BANK_CODE — VARCHAR(20)
- ACCOUNT_NO — VARCHAR(30)
- CREATED_AT — DATE
COMMUNITY
- ID — INT — NOT NULL
- STOCK_ID — INT — NOT NULL
- USER_ID — INT — NOT NULL
- BODY — TEXT
- CREATED_AT — DATE
FRIENDS
- ID — INT — NOT NULL
- USER_ID — INT — NOT NULL
- FRIEND_USER_ID — INT — NOT NULL
- CREATED_AT — DATE
HOLDING
- ID — INT — NOT NULL
- STOCK_ID — INT — NOT NULL
- ACCOUNT_ID — INT — NOT NULL
- QUANTITY — INT
- AVERAGE_PRICE — INT
- UPDATED_AT — DATE
LIKESTOCK
- ID — INT — NOT NULL
- USER_ID — INT — NOT NULL
- STOCK_ID — INT — NOT NULL
- CREATED_AT — DATE
ORDER_TABLE
- ID — INT — NOT NULL
- ACCOUNT_ID — INT — NOT NULL
- STOCK_ID — INT — NOT NULL
- QUANTITY — INT
- PRICE — INT
- TYPE — VARCHAR(10)
- CREATED_AT — DATE
QUEST
- ID — INT — NOT NULL
- TITLE — VARCHAR(100)
- DESCRIPTION — TEXT
- REWARD_TYPE — VARCHAR(20)
- REWARD_VALUE — INT
- STOCK_ID — INT
- IS_ACTIVE — VARCHAR(10)
- CREATED_AT — DATE
RANKING
- ID — INT — NOT NULL
- USER_ID — INT — NOT NULL
- RANK — INT
- TOTAL_ASSESTS — INT
- UPDATED_AT — DATE
STOCK
- ID — INT — NOT NULL
- CODE — VARCHAR(20)
- NAME — VARCHAR(100)
- DEFAULT_PRICE — INT
- LOGO_PIC — VARCHAR(255)
USER
- ID — INT — NOT NULL
- USER_ID — VARCHAR(100)
- PASSWORD — VARCHAR(100)
- PLATFORM — VARCHAR(20)
- NAME — VARCHAR(50)
- NICKNAME — VARCHAR(50)
- ROLE — VARCHAR(20)
- PHONE_NUMBER — VARCHAR(20)
- BIRTHDAY_YEAR — INT
- BIRTHDAY — VARCHAR(10)
- ACCESS — VARCHAR(20)
- BANKRUPT — INT
- CREATED_AT — DATE
USER_QUEST
- ID — INT — NOT NULL
- USER_ID — INT — NOT NULL
- QUEST_ID — INT — NOT NULL
- STATUS — VARCHAR(20)
- COMPLETED_AT — DATE