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