onlineShop

테이블 (18)

ADMIN_ROLE

  • ROLE_ID — NUMBER(10,0)
  • ROLE_NAME — VARCHAR2(50) — NOT NULL

ADMIN_USER

  • ADMIN_ID — NUMBER
  • NAME — VARCHAR2(50) — NOT NULL
  • PASSWORD — VARCHAR2(255) — NOT NULL
  • EMAIL — VARCHAR2(100) — NOT NULL
  • PHONE — VARCHAR2(20)
  • ROLE — VARCHAR2(20) — NOT NULL
  • IS_ACTIVE — CHAR(1)
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP
  • LAST_LOGIN_AT — TIMESTAMP
  • CHECK — (IS_ACTIVE IN ('Y', 'N'))

ADMIN_USER_ROLE

  • ADMIN_ID — NUMBER(10,0) — 외래 키 → ADMIN_USER.ADMIN_ID — NOT NULL
  • ROLE_ID — NUMBER(10,0) — 외래 키 → ADMIN_ROLE.ROLE_ID — NOT NULL

INQUIRY

  • INQUIRY_ID — NUMBER
  • USER_ID — NUMBER — NOT NULL
  • INQUIRY_TYPE — VARCHAR2(50) — NOT NULL
  • TITLE — VARCHAR2(200) — NOT NULL
  • CONTENT — CLOB — NOT NULL
  • ANSWER — CLOB
  • STATUS — VARCHAR2(20)
  • CREATED_AT — TIMESTAMP
  • ANSWERED_AT — TIMESTAMP
  • ANSWERED_BY — NUMBER — 외래 키 → ADMIN_USER.ADMIN_ID

INVOICE

  • INVOICE_ID — NUMBER(10,0)
  • INVOICE_CODE — VARCHAR2(255) — NOT NULL
  • INVOICE_COMPANY — VARCHAR2(255) — NOT NULL
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP

MEMBER

  • USER_ID — NUMBER(10,0)
  • NAME — VARCHAR2(100) — NOT NULL
  • PASSWORD — VARCHAR2(255) — NOT NULL
  • AGE — NUMBER — NOT NULL
  • GENDER — CHAR(1) — NOT NULL
  • EMAIL — VARCHAR2(100) — NOT NULL
  • PHONE — VARCHAR2(20)
  • ADDRESS — VARCHAR2(255)
  • JOIN_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP
  • WITHDRAW_AT — TIMESTAMP

NOTICE

  • NOTICE_ID — NUMBER
  • TITLE — VARCHAR2(200) — NOT NULL
  • CONTENT — CLOB — NOT NULL
  • VIEW_COUNT — NUMBER
  • IS_IMPORTANT — CHAR(1)
  • START_DATE — DATE
  • END_DATE — DATE
  • CREATED_AT — TIMESTAMP
  • CREATED_BY — NUMBER — 외래 키 → ADMIN_USER.ADMIN_ID
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — NUMBER — 외래 키 → ADMIN_USER.ADMIN_ID
  • CHECK — (IS_IMPORTANT IN ('Y', 'N'))

ORDERS

  • ORDER_ID — NUMBER
  • USER_ID — NUMBER — NOT NULL
  • ORDER_NUMBER — VARCHAR2(50) — NOT NULL
  • ORDER_STATUS — VARCHAR2(20) — NOT NULL
  • TOTAL_AMOUNT — NUMBER — NOT NULL
  • PAYMENT_METHOD — VARCHAR2(50)
  • PAYMENT_STATUS — VARCHAR2(20)
  • SHIPPING_ADDRESS — VARCHAR2(500)
  • SHIPPING_STATUS — VARCHAR2(20)
  • ORDER_DATE — TIMESTAMP
  • UPDATED_AT — TIMESTAMP
  • UPDATED_BY — NUMBER — 외래 키 → ADMIN_USER.ADMIN_ID
  • CHECK — (ORDER_STATUS IN ('PENDING', 'SHIPPED', 'DELIVERED', 'CANCELLED'))

ORDER_DETAIL

  • ORDER_DETAIL_ID — NUMBER
  • ORDER_ID — NUMBER — 외래 키 → ORDERS.ORDER_ID — NOT NULL
  • PRODUCT_ID — NUMBER — 외래 키 → PRODUCT.PRODUCT_ID — NOT NULL
  • QUANTITY — NUMBER — NOT NULL
  • UNIT_PRICE — NUMBER — NOT NULL
  • TOTAL_PRICE — NUMBER — NOT NULL

PAYMENTS

  • PAYMENT_ID — NUMBER(10,0)
  • ORDER_ID — NUMBER(10,0) — 외래 키 → ORDERS.ORDER_ID — NOT NULL
  • PAYMENT_METHOD — VARCHAR2(50) — NOT NULL
  • AMOUNT — NUMBER(10,2) — NOT NULL
  • STATUS — VARCHAR2(20)
  • CHECK — (PAYMENT_METHOD IN ('CARD', 'BANK_TRANSFER', 'PAYPAL'))
  • CHECK — (AMOUNT >= 0)
  • CHECK — (STATUS IN ('PENDING', 'COMPLETED', 'FAILED'))

PRODUCT

  • PRODUCT_ID — NUMBER
  • CATEGORY_ID — NUMBER — 외래 키 → PRODUCT_CATEGORY.CATEGORY_ID — NOT NULL
  • PRODUCT_NAME — VARCHAR2(200) — NOT NULL
  • PRODUCT_CODE — VARCHAR2(50) — NOT NULL
  • PRICE — NUMBER — NOT NULL
  • DISCOUNT_PRICE — NUMBER
  • STOCK_QUANTITY — NUMBER
  • PRODUCT_STATUS — VARCHAR2(20)
  • DESCRIPTION — CLOB
  • SEARCH_KEYWORDS — VARCHAR2(500)
  • VIEW_COUNT — NUMBER
  • IS_DISPLAY — CHAR(1)
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP
  • CREATED_BY — NUMBER — 외래 키 → ADMIN_USER.ADMIN_ID
  • UPDATED_BY — NUMBER — 외래 키 → ADMIN_USER.ADMIN_ID
  • CHECK — (IS_DISPLAY IN ('Y', 'N'))

PRODUCT_CATEGORY

  • CATEGORY_ID — NUMBER
  • PARENT_CATEGORY_ID — NUMBER — 외래 키 → PRODUCT_CATEGORY.CATEGORY_ID
  • CATEGORY_NAME — VARCHAR2(100) — NOT NULL
  • CATEGORY_DEPTH — NUMBER — NOT NULL
  • DISPLAY_ORDER — NUMBER
  • IS_ACTIVE — CHAR(1)
  • CREATED_AT — TIMESTAMP
  • CREATED_BY — NUMBER — 외래 키 → ADMIN_USER.ADMIN_ID
  • CHECK — (IS_ACTIVE IN ('Y', 'N'))

PRODUCT_IMAGE

  • IMAGE_ID — NUMBER
  • PRODUCT_ID — NUMBER — 외래 키 → PRODUCT.PRODUCT_ID — NOT NULL
  • IMAGE_URL — VARCHAR2(500) — NOT NULL
  • IMAGE_TYPE — VARCHAR2(20) — NOT NULL
  • DISPLAY_ORDER — NUMBER
  • CREATED_AT — TIMESTAMP

REVIEWS

  • REVIEW_ID — NUMBER(10,0)
  • USER_ID — NUMBER(10,0) — 외래 키 → MEMBER.USER_ID — NOT NULL
  • PRODUCT_ID — NUMBER(10,0) — 외래 키 → PRODUCT.PRODUCT_ID — NOT NULL
  • TITLE — VARCHAR2(500) — NOT NULL
  • CONTENT — CLOB — NOT NULL
  • RANK — NUMBER(2,0) — NOT NULL
  • CREATED_AT — DATE

SHIPPING

  • SHIP_ID — NUMBER(10,0)
  • INVOICE_ID — NUMBER(10,0) — 외래 키 → INVOICE.INVOICE_ID — NOT NULL
  • ORDER_ID — NUMBER(10,0) — 외래 키 → ORDERS.ORDER_ID — NOT NULL
  • NAME — VARCHAR2(100) — NOT NULL
  • PHONE — VARCHAR2(20) — NOT NULL
  • ZIPCODE — NUMBER(10,0) — NOT NULL
  • ADDRESS — VARCHAR2(255) — NOT NULL
  • SHIP_START_DATE — DATE
  • SHIP_END_DATE — DATE
  • STATUS — VARCHAR2(20)
  • CHECK — (STATUS IN ('PENDING', 'SHIPPED', 'DELIVERED'))

SYS_ATTACHFILE

  • FILE_ID — NUMBER
  • ORIGINAL_FILE_NAME — VARCHAR2(260) — NOT NULL — 원본
  • SAVED_FILE_NAME — VARCHAR2(260) — NOT NULL — 저장된
  • FILE_PATH — VARCHAR2(500) — NOT NULL — 파일
  • FILE_SIZE — NUMBER — NOT NULL — 파일
  • FILE_EXTENSION — VARCHAR2(20) — 파일
  • DOWNLOAD_COUNT — NUMBER — 다운로드
  • DELETE_YN — CHAR(1) — 삭제
  • CREATED_BY — VARCHAR2(50) — 등록자
  • CREATED_AT — DATE — 등록일시
  • UPDATED_BY — VARCHAR2(50) — 수정자
  • UPDATED_AT — DATE — 수정일시

공통코드 (SYS_CODE_INFO)

  • 그룹 코드 (GROUP_CODE) — VARCHAR2(10) — 외래 키 → 공통코드그룹.그룹 코드 — NOT NULL
  • 코드 (CODE) — VARCHAR2(10)
  • 코드 이름 (CODE_NAME) — VARCHAR2(10)
  • 정렬 순서 (SORT_ORDER) — VARCHAR2(10)
  • 사용유무 (USE_YN) — VARCHAR2(10)
  • 설명 (DESCRIPTION) — VARCHAR2(10)
  • 등록자 (REG_USER_ID) — VARCHAR2(10)
  • 등록일 (REG_DATE) — VARCHAR2(10)
  • 수정자 (MOD_USER_ID) — VARCHAR2(10)
  • 수정일 (MOD_DATE) — VARCHAR2(10)

공통코드그룹 (SYS_CODE_GRP_INFO)

  • 그룹 코드 (GROUP_CODE) — VARCHAR2(10) — 기본 키 — NOT NULL
  • 그룹이름 (GROUP_NAME) — VARCHAR2(10) — NOT NULL
  • 사용유무 (USE_YN) — VARCHAR2(10)
  • 설명 (DESCRIPTION) — VARCHAR2(10)
  • 등록자 (REG_USER_ID) — VARCHAR2(10)
  • 등록일 (REG_DATE) — VARCHAR2(10)
  • 수정자 (MOD_USER_ID) — VARCHAR2(10)
  • 수정일 (MOD_DATE) — VARCHAR2(10)