술:정
테이블 (12)
authority
- role — 기본 키 — NOT NULL
- code — number — 외래 키 → member.code — NOT NULL
funding
- code — number — 기본 키 — NOT NULL
- md_code — number — 외래 키 → member.code — NOT NULL
- title (Field)
- reward_name — VARCHAR2
- reward_price — number
- goal_price — number
- stack_price — number
- image — varchar2
- category — varchar2
- open_date — varchar2
- end_date — varchar2
- funding_state — varchar2
funding_answer
- code (question_code) — number — 외래 키 → funding_question.code — NOT NULL
- code (code2) — number — 외래 키 — NOT NULL
- content (contetn) — varchar2
- regdate — varchar2
funding_question
- code — number — 기본 키 — NOT NULL
- code (funding_code) — number — 외래 키 → funding.code — NOT NULL
- code (member_code) — number — 외래 키 → member.code — NOT NULL
- subject — varchar2
- content — varchar2
- regdate — varchar2
- state — varchar2
funding_request
- code — number — 기본 키 — NOT NULL
- code (member_code) — number — 외래 키 → member.code — NOT NULL
- subject — varchar2
- content — varchar2
- state — varchar2
like
- code — number — 기본 키 — NOT NULL
- code (member_code) — number — 외래 키 → member.code — NOT NULL
- code (funding_code) — number — 외래 키 → funding.code — NOT NULL
member
- code — number — 기본 키 — NOT NULL
- id — varchar2 — NOT NULL
- pwd — varchar2 — NOT NULL
- name — varchar2
- phone — varchar2
- addr — varchar2
- email — varchar2
- email_accept — varchar2(1)
notice
- code — number — 기본 키 — NOT NULL
- subject — varchar2
- content — varchar2
- regdate — varchar2
- filename — varchar2
personal_answer
- code (question_code) — number — 외래 키 → personal_question.code — NOT NULL
- content — varchar2
- regdate — varchar2
personal_question
- code — number — 기본 키 — NOT NULL
- code (member_code) — number — 외래 키 → member.code — NOT NULL
- subject — varchar2
- content — varchar2
- regdate — varchar2
- state — varchar2
purchase
- code — number — 기본 키 — NOT NULL
- code (member_code) — number — 외래 키 → member.code — NOT NULL
- code (funding_code) — number — 외래 키 → funding.code — NOT NULL
- qty — number
- price — number
- purchase_state — varchar2
- purchase_date — varchar2
- delivery_number — varchar2
- Courier — varchar2
statistics
- date — number — 기본 키 — NOT NULL
- visit — number
- purchase_price — number
- purchase_count — number
- funding_apply — NUMBER