HR

Tables (21)

ACCOUNT (계좌)

  • SERIALNUM (고유 번호) — NUMBER — Primary key — NOT NULL
  • MEMBERID (ID) — VARCHAR2(20) — Foreign key → MEMBER.MEMBERID — NOT NULL
  • BANKBOOKNUM (통장 상품 번호) — NUMBER — Foreign key → BANKBOOK.BANKBOOKNUM — NOT NULL
  • ACCOUNTNUM (계좌 번호) — VARCHAR2(200)
  • OPENDATE (개설일) — DATE
  • BALANCE (잔액) — NUMBER

BANKBOOK (통장 상품)

  • BANKBOOKNUM (통장 상품 번호) — NUMBER — Primary key — NOT NULL
  • BANKBOOKNAME (통장 상품 이름) — VARCHAR2(200)
  • INTERESTRATE (이자율) — NUMBER(3,1)
  • BANKBOOKDETAIL (상세 내용) — CLOB
  • SALECHECK (판매 여부) — NUMBER(1)

BANKBOOKCOMMENTS (통장 상품 댓글)

  • NUM (댓글 번호) — NUMBER — Primary key — NOT NULL
  • BANKBOOKNUM (통장 상품 번호) — NUMBER — Foreign key → BANKBOOK.BANKBOOKNUM — NOT NULL
  • CONTENTS (댓글 내용) — VARCHAR2(4000)
  • REGDATE (작성일) — DATE
  • WRITER (작성자) — VARCHAR2(200)

BANKBOOKIMG (상품 이미지)

  • FILENUM (파일 번호) — NUMBER — Primary key — NOT NULL
  • BANKBOOKNUM (통장 상품 번호) — NUMBER — Foreign key → BANKBOOK.BANKBOOKNUM — NOT NULL
  • FILENAME (저장된 파일명) — VARCHAR2(400)
  • ORINAME (업로드 시 파일명) — VARCHAR2(400)

BANKING (은행 업무)

  • SERIALNUM (고유 번호) — NUMBER — Foreign key → ACCOUNT.SERIALNUM — NOT NULL
  • MEMBERID (ID) — VARCHAR2(20) — Foreign key → ACCOUNT.MEMBERID — NOT NULL
  • BANKBOOKNUM (통장 상품 번호) — NUMBER — Foreign key → ACCOUNT.BANKBOOKNUM — NOT NULL
  • BANKINGDATE (입출금 일자) — DATE
  • BANKINGCHECK (입출금 여부) — NUMBER(1)
  • TRANSFER (이체 내역) — NUMBER

COMMENTS (댓글)

  • COMMNETNUM (댓글 번호) — NUMBER — Primary key — NOT NULL
  • PRODUCTNUM (상품 번호) — NUMBER — Foreign key → PRODUCT.PRODUCTNUM — NOT NULL
  • COMMENTID (작성자) — VARCHAR2 — Foreign key → MEMBER.MEMBERID — NOT NULL
  • COMMENTRATING (평점) — NUMBER — NOT NULL
  • COMMENTUPLOADDATE (등록 날짜) — DATE — NOT NULL
  • COMMNETDETAIL (내용) — CLOB

COUNTRIES (국가 정보)

  • COUNTRY_ID (Key) — VARCHAR2 — Primary key — NOT NULL
  • REGION_ID (Key2) — NUMBER — Foreign key → REGIONS.REGION_ID — NOT NULL
  • COUNTRY_NAME (Field) — VARCHAR2

DELIVERY (배송지)

  • DELIVERYNUM (배송 번호) — Primary key — NOT NULL
  • DELIVERYID (ID) — VARCHAR2(20) — Foreign key → MEMBER.MEMBERID — NOT NULL
  • DELIVERYADDRESS (주소) — VARCHAR2(200)
  • DELIVERYPHONE (전화 번호) — VARCHAR2(50)
  • DELIVERYNAME (이름) — VARCHAR2(20)

DEPARTMENTS (부서 정보)

  • DEPARTMENT_ID (Key) — NUMBER — Primary key — NOT NULL
  • LOCATIONS_ID (Key2) — NUMBER — Foreign key → LOCATIONS.LOCATIONS_ID — NOT NULL
  • DEPARTMENT_NAME (Field) — VARCHAR2
  • MANAGER_ID (Field2) — NUMBER

EMPLOYEES (사원 정보)

  • EMPLOYEE_ID (Key) — NUMBER — Primary key — NOT NULL
  • DEPARTMENT_ID (Key2) — NUMBER — Foreign key → DEPARTMENTS.DEPARTMENT_ID — NOT NULL
  • FIRST_NAME (Field) — VARCHAR2
  • LAST_NAME (Field2) — VARCHAR2
  • EMAIL (Field3) — VARCHAR2
  • PHONE_NUMBER (Field4) — VARCHAR2
  • HIRE_DATE (Field5) — DATE
  • JOB_ID (Field6) — VARCHAR2
  • SALARY (Field7) — NUMBER
  • COMMISSION_PCT (Field8) — NUMBER
  • MANAGER_ID (Field9) — NUMBER

LOCATIONS (지역 정보)

  • LOCATIONS_ID (Key) — NUMBER — Primary key — NOT NULL
  • COUNTRY_ID (Key2) — VARCHAR2 — Foreign key → COUNTRIES.COUNTRY_ID — NOT NULL
  • STREET_ADDRESS (Field) — VARCHAR2
  • POSTAL_CODE (Field2) — VARCHAR2
  • CITY (Field3) — VARCHAR2
  • STATE_PROVINCE (Field4) — VARCHAR2

MEMBER (회원)

  • MEMBERID (ID) — VARCHAR2(20) — Primary key — NOT NULL
  • MEMBERPW (PW) — VARCHAR2(20)
  • MEMBERNAME (이름) — VARCHAR2(20)
  • MEMBERADDRESS (주소) — VARCHAR2(200)
  • MEMBERPHONE (전화 번호) — VARCHAR2(50)
  • MEMBEREMAIL (EMAIL) — VARCHAR2(50)

MEMBER_ROLE (멤버 권한)

  • MEMBERID (ID) — VARCHAR2(20) — Foreign key → MEMBER.MEMBERID — NOT NULL
  • ROLENUM (권한 번호) — NUMBER — Foreign key → ROLE.ROLENUM — NOT NULL

NOTICE (공지사항)

  • NUM (글 번호) — NUMBER — Primary key — NOT NULL
  • TITLE (글 제목) — VARCHAR2(200)
  • CONTENTS (글 내용) — CLOB
  • WRITER (작성자) — VARHCAR2(200)
  • REGDATE (작성일) — DATE
  • HIT (조회수) — NUMBER

NOTICEFILES (공지사항 파일)

  • FILENUM (파일 번호) — NUMBER — Primary key — NOT NULL
  • NUM (글 번호) — NUMBER — Foreign key → NOTICE.NUM — NOT NULL
  • FILENAME (파일 이름) — VARCHAR2(200)
  • ORINAME (업로드명) — VARCHAR2(200)

PRODUCT (상품들)

  • PRODUCTNUM (상품 번호) — NUMBER — Primary key — NOT NULL
  • PRODUCTNAME (상품명) — VARCHAR(200) — NOT NULL
  • PRODUCTDETAIL (제품 설명) — CLOB — NOT NULL
  • PRODUCTRATING (평점) — NUMBER(2, 1) — NOT NULL

PRODUCT OPTION (상품 옵션)

  • OPTIONNUM (옵션 번호) — NUMBER — Primary key — NOT NULL
  • PRODUCTNUM (상품 번호) — NUMBER — Foreign key → PRODUCT.PRODUCTNUM — NOT NULL
  • OPTIONNAME (옵션명) — VARCHAR2(50) — NOT NULL
  • OPTIONPRICE (옵션 가격) — NUMBER — NOT NULL
  • OPTIONSTOCK (옵션 재고) — NUMBER — NOT NULL

QNA (질문/답변게시판)

  • NUM (글 번호) — NUMBER — Primary key — NOT NULL
  • TITLE (글 제목) — VARCHAR2(200)
  • CONTENTS (글 내용) — CLOB
  • WRITER (작성자) — VARHCAR2(200)
  • REGDATE (작성일) — DATE
  • HIT (조회수) — NUMBER
  • REF (Field) — NUMBER
  • STEP (Field2) — NUMBER
  • DEPTH (Field3) — NUMBER

QNAFILES (질문/답변게시판 파일)

  • FILENUM (파일 번호) — NUMBER — Primary key — NOT NULL
  • NUM (글 번호) — NUMBER — Foreign key → QNA.NUM — NOT NULL
  • FILENAME (파일 이름) — VARCHAR2(200)
  • ORINAME (업로드명) — VARCHAR2(200)

REGIONS (대륙 정보)

  • REGION_ID (Key) — NUMBER — Primary key — NOT NULL
  • REGION_NAME (Field) — VARCHAR2

ROLE (권한)

  • ROLENUM (권한 번호) — NUMBER — Primary key — NOT NULL
  • ROLENAME (권한 이름) — VARCHAR2(20)