술:정

테이블 (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