test
Tables (8)
Balances
- BalanceID — NUMBER
- MemberID — NUMBER — NOT NULL
- CurrentBalance — NUMBER(10, 2) — NOT NULL
- LastUpdateDateTime — TIMESTAMP(6) — NOT NULL
Events
- EventID — NUMBER
- GroupID — NUMBER — NOT NULL
- Title — VARCHAR2(200) — NOT NULL
- Description — VARCHAR2(4000)
- EventDate — DATE — NOT NULL
- StartTime — TIMESTAMP(0)
- EndTime — TIMESTAMP(0)
- Location — VARCHAR2(200)
Groups
- GroupID — NUMBER
- GroupName — VARCHAR2(100) — NOT NULL
- GroupCreationDate — DATE — NOT NULL
- GroupLeaderID — NUMBER
MemberHistory
- HistoryID — NUMBER
- MemberID — NUMBER — NOT NULL
- EventType — VARCHAR2(50) — NOT NULL
- EventDateTime — TIMESTAMP(6) — NOT NULL
Members
- MemberID — NUMBER
- Name — VARCHAR2(100) — NOT NULL
- PhoneNumber — VARCHAR2(20)
- Email — VARCHAR2(100)
- JoinDate — TIMESTAMP(6) — NOT NULL
- Status — VARCHAR2(50)
- GroupID — NUMBER — NOT NULL
- Position — VARCHAR2(50)
- Permissions — VARCHAR2(100)
MembershipFee
- FeeID — NUMBER
- GroupID — NUMBER — NOT NULL
- FeeAmount — NUMBER(10, 2) — NOT NULL
- FeeDate — DATE — NOT NULL
Notices
- NoticeID — NUMBER
- GroupID — NUMBER — NOT NULL
- Title — VARCHAR2(200) — NOT NULL
- Content — VARCHAR2(4000) — NOT NULL
- NoticeDate — DATE — NOT NULL
Transactions
- TransactionID — NUMBER
- MemberID — NUMBER — NOT NULL
- TransactionDateTime — TIMESTAMP(6) — NOT NULL
- TransactionType — VARCHAR2(50) — NOT NULL
- Amount — NUMBER(10, 2) — NOT NULL
- Description — VARCHAR2(200)