정수기렌탈 리팩토링(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