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)