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