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)