flowerpot
화장품 쇼핑몰 사이트
테이블 (26)
Copy Of Copy Of Untitled (f_coupon)
- Key (couNo) — number — 기본 키 — NOT NULL
- Field (couponName) — varchar2
- Field (discountMoney) — number — 원
- Field (discountPercent) — number — 퍼센트
- Field (start_date) — date
- Field (end_date) — date
- Field (enable) — number
Copy Of Untitled (f_hasCoupon)
- Key (hasCno) — number — 기본 키 — NOT NULL
- Key (mno) — number — 외래 키 → member.Key — NOT NULL
- Key (couNo) — number — 외래 키 → Copy Of Copy Of Untitled.Key — NOT NULL
Untitled (f_attachFile)
- Key (atno) — number — 기본 키 — NOT NULL
- Key (cno) — number — 외래 키 → Untitled.Key — NOT NULL
- Key (mgno) — number — 외래 키 → cosmetic.Key — NOT NULL
- Key (eno) — number — 외래 키 → Untitled.Key — NOT NULL
- Key (crno) — number — 외래 키 → Untitled.Key — NOT NULL
- Field (uuidName) — varchar2
- Field (originalFileName) — varchar2
- Field (uploadFolderPath) — varchar2
- Field (mappingURL) — varchar2
- Field (realName) — varchar2
- Field (imge) — char(1)
Untitled (f_reply)
- Key (rno) — number — 기본 키 — NOT NULL
- Key (ccno) — number — 외래 키 → customerCenter.Key — NOT NULL
- Key (mno) — number — 외래 키 → member.Key — NOT NULL
- Field (name) — varchar2
- Field (title) — varchar2
- Field (content) — varchar2
- Field (regdate) — date
- Field (moddate) — date
Untitled (f_attendance)
- Key (mno) — number — 외래 키 → member.Key — NOT NULL
- Field (attendance_date) — date
Untitled (comments)
- Key (rno) — number — 기본 키 — NOT NULL
- Key (ccno) — number — 외래 키 → customerCenter.Key — NOT NULL
- Field (replyer) — varchar2
- Field (replytitle) — varchar2
- Field (replytext) — varchar2
- Field (regdate) — date
- Field (updatedate) — date
Untitled (f_order)
- Key (orderno) — number — 기본 키 — NOT NULL
- Key (mno) — number — 외래 키 → member.Key — NOT NULL
- Key (dno) — number — 외래 키 → Untitled.Key — NOT NULL
- Field (order_num) — varchar2
- Field (final_price) — number
- Field (regdate) — date
Untitled (position)
- Field (poNo) — number
- Field (poName) — varchar
Untitled (department)
- Field (deptNo) — number
- Field (deptName) — varchar
Untitled (employee)
- Field (empNo) — number
- Field2 (empId) — varchar
- Field3 (empName) — varchar
- Field4 (empEnabled) — char
- Field5 (deptNo) — int
- Field (poNo) — int
Untitled (f_type)
- Field (type) — varchar2 — 이 테이블은 카테고리 정보 테이블 입니다
- Field (sub_type) — varchar2
Untitled (f_memberAddress)
- Key (mno) — number — 외래 키 → member.Key — NOT NULL
- Field (postcode) — varchar2
- Field (street_address) — varchar2
- Field2 (parcel_address) — varchar2
- Field3 (detail_address) — varchar2
- Field4 (more_infomation) — varchar2
Untitled (f_delivery)
- Key (dno) — number — 기본 키 — NOT NULL
- Field (id) — varchar2
- Field (t_code) — varchar2
- Field (t_invoice) — varchar2
- Field (postcode) — varchar2 — 우편변호
- Field (street_address) — varchar2 — 도로명주소
- Field (parcel_address) — varchar2 — 지번주소
- Field (detail_address) — varchar2 — 상세주소
- Field (more_infomation) — varchar2 — 추가정보
- Field (deliver_state) — varchar2
Untitled (f_brand)
- Key (bno) — number — 기본 키 — NOT NULL
- Field (name) — varchar2
- Field (company) — varchar2
- Field (brandName) — varchar2
- Field2 (busNo) — varchar2
- Field3 (ceoName) — varchar2
- Field (tel) — varchar2 — 회사전화번호
- Field4 (email) — varchar2
- Field5 (postcode) — varchar2
- Field6 (roadAddr) — varchar2
- Field7 (jibunAddr) — varchar2
- Field (extraAddr) — varchar2
- Field2 (detailAddr) — varchar2
- Field (introduce) — varchar2
- Field (regDate) — date
Untitled (f_authority)
- Key (auno) — number — 기본 키 — NOT NULL
- Field (id) — varchar2
- Field (authority) — varchar2
Untitled (f_event)
- Key (eno) — number — 기본 키 — NOT NULL
- Key (mno) — number — 외래 키 → member.Key — NOT NULL
- Field (title) — varchar2
- Field (content) — varchar2
- Field (enable) — number
- Field (regdate) — date
- Field (moddate) — date
Untitled (f_hasComponent)
- Key (cno) — number — 외래 키 → Untitled.Key — NOT NULL
- Key (cnum) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (f_component)
- Key (cpno) — int — 기본 키 — NOT NULL
- Field (cname) — varchar2 — 성분이름
- Field (ename) — varchar2 — 영문이름
- Field2 (allergy) — char(1)
- Field (oil) — char(1) — 지성피부에 어떤 영향인지
- Field (dry) — char(1) — 건성피부에 어떤 영향인지
- Field (sensitive) — char(1) — 민감성피부에 어떤 영향인지
- Field (sunblock) — char(1) — 자외선 차단 여부
- Field (whitening) — char(1) — 미백개선여부
- (wrinkle) — char(1) — 주름개선여부
Untitled (f_orderProduct)
- Key (ono) — number — 기본 키 — NOT NULL
- Key (mno) — number — 외래 키 → member.Key — NOT NULL
- Key (cno) — number — 외래 키 → Untitled.Key — NOT NULL
- Key (dno) — number — 외래 키 → Untitled.Key — NOT NULL
- Field (order_num) — varchar2 — 통합 주문번호
- Field (amount) — number
- Field (state) — varchar2 — 주문상태 : - 판매완료 - 환불완료 - 교환완료
- Field (deliver_state) — varchar2 — 배달 상태 : 1. 배송중 2. 배송완료
- Field (member_rank) — varchar2
- Field (point) — number — 사용 포인트
- Field (couponName) — varchar2 — 쿠폰이름
- Field (name) — varchar2
- Field (tel) — number
- Field (email) — varchar2
- Field (final_price) — number
- Field (brand) — varchar2
- Field (discountPersent) — number
- Field (regdate) — date
Untitled (f_cosmeticReview)
- Key (crno) — number — 기본 키 — NOT NULL
- Key (mno) — number — 외래 키 → member.Key — NOT NULL
- Key (cno) — number — 외래 키 → Untitled.Key — NOT NULL
- Field (category) — varchar2 — 상품문의 / 상품평
- Field (id) — varchar2
- Field (nickname) — varchar2
- Field (title) — varchar2
- Field (content) — varchar2
- Field (image) — varchar2 — 이미지 경로들
- Field (rating) — number — 평점
- Field (regdate) — date
Untitled (f_point)
- Key (pno) — number — 기본 키 — NOT NULL
- Key (mno) — number — 외래 키 → member.Key — NOT NULL
- Key (ono) — number — 외래 키 → Untitled.Key — NOT NULL
- Field (add_point) — number
- Field (order_num) — varchar2 — 주문번호
- Field (regdate) — date
Untitled (f_description)
- Key (cno) — number — 외래 키 → Untitled.Key — NOT NULL
- Field (capacity) — number — 용량
- Field (period) — number — 개월수 기준, 사용기간
- Field (useMethod) — varchar2 — 사용방법
- (nation) — varchar2 — 제조국
Untitled (f_cosmetic)
- Key (cno) — number — 기본 키 — NOT NULL
- Field (name) — varchar2
- Field (code) — varchar2
- Field (type) — varchar2 — 유형별
- Field (sub_type) — varchar2 — 페이셜, 마스크팩, 클렌징.. 로션,
- Field (brand) — varchar2 — 브랜드별
- Field (skintype) — varchar2
- Field (price) — number — 가격
- Field (tag) — varchar2 — 태그
- Field (content) — varchar2
- Field (discountPersent) — number — 할인률
- Field (stockNumber) — number — 재고
- Field (hits) — number — 조회수
- Field (likey) — number
- Field (enable) — number
- Field (numProduct) — number
- Field (regdate) — date
- Field (component) — varchar2
cosmetic (f_magazine)
- Key (mgno) — number — 기본 키 — NOT NULL
- Key (mno) — number — 외래 키 → member.Key — NOT NULL
- Field (title) — varchar2
- Field (name) — varchar2
- Field (content) — varchar2
- Field (category) — varchar2
- Field (regdate) — date
- Field (moddate) — date
- Field (UUIDName) — varchar2
- Field (originalName) — varchar2
- Field (rootfloder) — varchar2
customerCenter (f_customerCenter)
- Key (ccno) — number — 기본 키 — NOT NULL
- Key (mno) — number — 외래 키 → member.Key — NOT NULL
- Field (title) — varchar2
- Field (content) — varchar2
- Field (regdate) — date
- Field (moddate) — date
- Field (category) — varchar2
- Field (url) — varchar2
member (f_member)
- Key (mno) — number — 기본 키 — NOT NULL
- Field (id) — varchar2
- Field (password) — varchar2
- Field (name) — varchar2
- Field (nickname) — varchar2
- Field (email) — varchar2
- Field (tel) — varchar2
- Field (gender) — varchar2 — M F 나중에 제약조건 걸기
- Field (birth) — varchar2
- Field (member_rank) — number — 골드, 실버, 브론즈, 플래티넘
- Field (regdate) — date
- Field (point) — number
- Field (enable) — char(1)
- Field (brand) — varchar2