정수기렌탈 리팩토링(MY)

테이블 (7)

Attach

  • uuid — VARCHAR2(500) — 기본 키 — NOT NULL
  • folderPath — VARCHAR2(1000) — NOT NULL
  • fileName — VARCHAR2(500) — NOT NULL
  • product_no — NUMBER — 외래 키 → Product.product_no — NOT NULL

Inquiry

  • proq_no — NUMBER — 기본 키 — NOT NULL
  • proq_title — VARCHAR2(500) — NOT NULL
  • proq_content — VARCHAR2(1500) — NOT NULL
  • proq_state — VARCHAR2(500) — NOT NULL
  • proq_awn_date — DATE
  • proq_awn_content — VARCHAR2(1500)
  • proq_date — DATE — NOT NULL
  • mem_no — NUMBER — 외래 키 → Member.mem_no — NOT NULL
  • product_no — NUMBER — 외래 키 → Product.product_no — NOT NULL

Member

  • mem_no — NUMBER — 기본 키 — NOT NULL
  • mem_id — VARCHAR2(100) — NOT NULL
  • mem_pw — VARCHAR2(200) — NOT NULL
  • mem_name — VARCHAR2(200) — NOT NULL
  • mem_phone — VARCHAR2(255) — NOT NULL
  • mem_email — VARCHAR2(255) — NOT NULL
  • auth — VARCHAR2(255) — NOT NULL
  • status — NUMBER — NOT NULL

Orders

  • order_no — NUMBER — 기본 키 — NOT NULL
  • mem_no — NUMBER — 외래 키 → Member.mem_no — NOT NULL
  • product_no — NUMBER — 외래 키 → Product.product_no — NOT NULL
  • order_state — VARCHAR2(500) — NOT NULL
  • order_devDate — DATE — NOT NULL
  • order_devTime — VARCHAR2(500) — NOT NULL
  • order_addNumber — VARCHAR2(500) — NOT NULL
  • order_address — VARCHAR2(1000) — NOT NULL
  • order_addDetail — VARCHAR2(1000) — NOT NULL
  • order_name — VARCHAR2(500) — NOT NULL
  • order_phone — VARCHAR2(500) — NOT NULL
  • order_price — NUMBER
  • order_date — DATE — NOT NULL
  • order_pay — VARCHAR2(500) — NOT NULL
  • rental_price — NUMBER
  • rental_term — NUMBER
  • rental_payDate — VARCHAR2(50)

Product

  • product_no — NUMBER — 기본 키 — NOT NULL
  • product_name — VARCHAR2(500) — NOT NULL
  • product_size — VARCHAR2(500) — NOT NULL
  • product_weight — VARCHAR2(100) — NOT NULL
  • proudct_detail — VARCHAR2(1000) — NOT NULL
  • product_guide — VARCHAR2(500) — NOT NULL
  • product_type — VARCHAR2(100) — NOT NULL
  • product_method — VARCHAR2(100) — NOT NULL
  • product_rdate — DATE — NOT NULL
  • product_company — VARCHAR2(100) — NOT NULL
  • regDate — DATE — NOT NULL
  • updateDate — DATE
  • img_url — VARCHAR2(1000) — NOT NULL
  • detail_url — VARCHAR2(1000) — NOT NULL
  • product_sales — NUMBER — NOT NULL
  • product_function — VARCHAR2(500) — NOT NULL
  • product_model — VARCHAR2(500) — NOT NULL
  • product_rentalPrice — NUMBER — NOT NULL
  • product_price — NUMBER — NOT NULL
  • product_color — VARCHAR2(100) — NOT NULL

Return

  • return_no — NUMBER — 기본 키 — NOT NULL
  • return_date — DATE — NOT NULL
  • return_time — VARCHAR2(100) — NOT NULL
  • return_price — NUMBER
  • return_method — VARCHAR2(200)
  • return_true — CHAR(1) — NOT NULL
  • order_no — NUMBER — 외래 키 → Orders.order_no — NOT NULL
  • mem_no — NUMBER — 외래 키 → Member.mem_no — NOT NULL
  • product_no — NUMBER — 외래 키 → Product.product_no — NOT NULL

Review

  • re_no — NUMBER — 기본 키 — NOT NULL
  • order_no — NUMBER — 외래 키 → Orders.order_no — NOT NULL
  • mem_no — NUMBER — 외래 키 → Member.mem_no — NOT NULL
  • re_star — VARCHAR2(10) — NOT NULL
  • re_image — VARCHAR2(500)
  • re_content — VARCHAR2(1000) — NOT NULL
  • re_date — DATE — NOT NULL
  • product_no — NUMBER — 외래 키 → Product.product_no — NOT NULL