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)