semi
Tables (5)
CHALLENGE
- Key (SEQ) — NUMBER — Primary key — NOT NULL
- Field (TITLE) — VARCHAR2
- Field (CONTENT) — VARCHAR2
- Field (START_DATE) — DATE
- Field (END_DATE) — DATE
- Field (END) — VARCHAR2
- Field (TOTAL_PATICIPATE) — NUMBER
- Field (FILE_PATH) — VARCHAR2
- Field (GIVEORTAKE) — VARCHAR2
- Field (CATEGORY) — VARCHAR2
- Field (PP_POINT) — NUMBER
- Field (TOTAL_AMOUNT) — NUMBER
- Field (DETAILCONTENT) — VARCHAR2
CHALLENGE_RECORD
- Key (SEQ) — NUMBER — Primary key — NOT NULL
- SEQ (SEQ2) — NUMBER — Foreign key → MEMBER.SEQ — NOT NULL
- Key (CHALLENGE_NUMM) — NUMBER — Foreign key → CHALLENGE.Key — NOT NULL
- Field (SUCCESS) — VARCHAR2
- Field (MEMBER_ID) — VARCHAR2
- Field (ENJOYDATE) — DATE
FILE_LIST
- Key (SEQ) — NUMBER — Primary key — NOT NULL
- SEQ (CHALLENGE_RECORD_NUM) — NUMBER — Foreign key → CHALLENGE_RECORD.SEQ — NOT NULL
- Field (FILE_NAME) — VARCHAR2
- Field (FILE_PATH) — VARCHAR2
- Field (ORIGINAL_NAME) — VARCHAR2
- Field (UPLOAD_DATE) — VARCHAR2
MEMBER
- SEQ — NUMBER — Primary key — NOT NULL
- ID — VARCHAR2
- PW — VARCHAR2
- Field (NAME) — VARCHAR2
- Field (PHONE) — VARCHAR2
- Field (EMAIL) — VARCHAR2
- Field (POINT) — NUMBER
- Field (GETOUT) — VARCHAR2
PAYMENT
- Key (SEQ) — NUMBER — Primary key — NOT NULL
- SEQ (SEQ2) — NUMBER — Foreign key → MEMBER.SEQ — NOT NULL
- Field (POINT) — NUMBER
- Field (PAYMENT_DATE) — DATE
- Field (RECEIPT_ID) — VARCHAR2
- Field (COMPANY) — VARCHAR2
- Field (MEMBER_ID) — VARCHAR2