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