FundingAdventure

Tables (8)

answer

  • num — NUMBER — Primary key — NOT NULL
  • q_num — NUMBER — NOT NULL
  • m_num — NUMBER — NOT NULL
  • content — CLOB — NOT NULL
  • date — DATE — NOT NULL

gift

  • num — NUMBER — NOT NULL
  • p_num — NUMBER
  • price — NUMBER
  • name — VARCHAR2(20)
  • intro — VARCHAR2(100)
  • name — VARCHAR2(20) — NOT NULL
  • reg_date — DATE — NOT NULL
  • mod_date — date — NOT NULL
  • phone — VARCHAR2(20) — NOT NULL
  • phone_confirm — NUMBER — NOT NULL
  • email — VARCHAR2(20) — NOT NULL
  • photo — VARCHAR2(20) — NOT NULL
  • zipcode — NUMBER — NOT NULL
  • address — VARCHAR2(50) — NOT NULL
  • address_detail — VARCHAR2(20) — NOT NULL

member (Member)

  • num — NUMBER — Primary key — NOT NULL
  • id — VARCHAR2(20) — NOT NULL
  • grade — NUMBER — NOT NULL

member_detail

  • num (member_num) — NUMBER — Primary key — NOT NULL
  • pass — VARCHAR2(20) — NOT NULL
  • name — VARCHAR2(20) — NOT NULL
  • reg_date — DATE — NOT NULL
  • mod_date — date — NOT NULL
  • phone — VARCHAR2(20) — NOT NULL
  • phone_confirm — NUMBER — NOT NULL
  • email — VARCHAR2(20) — NOT NULL
  • photo — VARCHAR2(20) — NOT NULL
  • zipcode — NUMBER — NOT NULL
  • address — VARCHAR2(50) — NOT NULL
  • address_detail — VARCHAR2(20) — NOT NULL
  • m_num (Field) — number

notice

  • num — NUMBER
  • p_num — NUMBER
  • title — VARCHAR2(20)
  • content — CLOB

project

  • num — NUMBER — Primary key — NOT NULL
  • name — VARCHAR2(50) — NOT NULL
  • category — NUMBER — NOT NULL
  • start_date — DATE — NOT NULL
  • finish_date — DATE — NOT NULL
  • goal_amount — NUMBER — NOT NULL
  • m_num — NUMBER — NOT NULL
  • approval — NUMBER — NOT NULL
  • reason — VARCHAR2(100)
  • summary — VARCHAR2(200)
  • photo — VARCHAR(20)
  • ship — NUMBER
  • intro — CLOB
  • policy — CLOB

question

  • num — NUMBER — Primary key — NOT NULL
  • m_num — NUMBER — NOT NULL
  • p_num — NUMBER
  • title — VARCHAR2(20) — NOT NULL
  • content — CLOB — NOT NULL
  • password — VARCHAR2(20)
  • date — DATE — NOT NULL

support

  • num — NUMBER — Primary key — NOT NULL
  • m_num — NUMBER — NOT NULL
  • p_num — NUMBER — NOT NULL
  • payment — NUMBER — NOT NULL
  • g_num — NUMBER — NOT NULL
  • support_amount — NUMBER — NOT NULL