MJDonor

Tables (4)

DONATION (Untitled4)

  • PK (DONATE_DATE) — DATE — Primary key — NOT NULL
  • P_ID — NUMBER(38,0) — Foreign key → PROJECT.P_ID — NOT NULL
  • U_ID (USER_ID) — NUMBER(38,0) — Foreign key → USERS.U_ID — NOT NULL
  • Field (NICKNAME) — VARCHAR2(255 BYTE)
  • Field (POINT) — NUMBER(38,0)
  • Field (REFUND) — VARCHAR2(255 BYTE)
  • Field (MSG) — VARCHAR2(255 BYTE)
  • Field (RBANK) — VARCHAR2(255 BYTE)
  • Field (VACCOUNT) — VARCHAR2(255 BYTE)
  • Field (LIMIT) — DATE
  • Field (DEPOSIT) — NUMBER
  • Field (REFUND_STATE) — NUMBER

ORGANIZATION (Untitled2)

  • O_ID (Field) — NUMBER(38,0) — Primary key — NOT NULL
  • NAME (Field2) — VARCHAR2(255 BYTE)
  • IMAGE (Field3) — VARCHAR2(255 BYTE)

PROJECT (Untitled3)

  • P_ID (PK) — NUMBER(38,0) — Primary key — NOT NULL
  • ORGANIZATION_ID (O_ID) — NUMBER(38,0) — Foreign key → ORGANIZATION.O_ID — NOT NULL
  • REGISTRANT_ID (U_ID) — NUMBER(38,0) — Foreign key → USERS.U_ID — NOT NULL
  • NAME (Field3) — VARCHAR2(255 BYTE)
  • DESCRIPTION (Field4) — VARCHAR2(255 BYTE)
  • TARGET_POINT (Field5) — NUMBER(38,0)
  • CURRENT_POINT (Field6) — NUMBER(38,0)
  • START_DATE (Field7) — DATE
  • END_DATE (Field8) — DATE
  • SUCCESS (Field9) — CHAR(1 BYTE)
  • CATEGORY (Field10) — VARCHAR2(100 BYTE)
  • IMAGE1 (Field11) — VARCHAR2(255 BYTE)
  • IMAGE2 (Field12) — VARCHAR2(255 BYTE)
  • CONTRACT_ADDRESS (Field13) — VARCHAR2(255 BYTE)

USERS (Untitled)

  • U_ID (PK) — NUMBER(38,0) — Primary key — NOT NULL
  • EMAIL (Field) — VARCHAR2(255 BYTE)
  • NAME (Field2) — VARCHAR2(255 BYTE)
  • PASSWORD (Field3) — VARCHAR2(255 BYTE)
  • CREATED_AT (Field4) — DATE
  • POINT (Field5) — NUMBER(38,0)
  • WALLET (Field6) — VARCHAR2(255 BYTE)
  • PHOTO (Field7) — VARCHAR2(4000 BYTE)