HR

Tables (29)

ACCOUNT

  • ACCOUNTNUMBER (Key) — Primary key — NOT NULL
  • BOOKNUMBER — NUMBER — Foreign key → BANKBOOK.BOOKNUMBER — NOT NULL
  • ID — VARCHAR2(200) — Foreign key → MEMBER.ID — NOT NULL
  • ACCOUNTDATE (개설일) — DATE
  • ACCOUNTBALANCE (전체잔액) — NUMBER

ADDRESS (배송지)

  • SHIPPING_NUM (배송번호) — NUMBER — Primary key — NOT NULL
  • ID — VARCHAR2(200) — Foreign key → MEMBER.ID — NOT NULL
  • ADDRESS (주소) — VARCHAR2(200)
  • PHONE_NUM (전화번호) — VARCHAR2(200)
  • NAME (이름) — VARCHAR2(200)

BANKBOOK

  • BOOKNUMBER — NUMBER — Primary key — NOT NULL
  • BOOKNAME — VARCHAR2(100)
  • BOOKRATE — NUMBER(3,2)
  • BOOKSALE — NUMBER(1)
  • BOOKDETAIL — CLOB

BANK_PRODUCT (통장 상품)

  • PRODUCTNUM (통장상품번호) — NUMBER — Primary key — NOT NULL
  • INTEREST (이자율) — NUMBER(2,1)
  • PRODUCTNAME (상품이름) — VARCHAR2(200)
  • PRODUCTOPTION (상세내용) — CLOB
  • PRODUCTSELL (판매여부) — VARCHAR2(200)

CARD (카드)

  • CARDNUM (카드번호) — NUMBER — Primary key — NOT NULL
  • CVC — NUMBER(3)
  • AMOUNT (카드사용금액) — NUMBER
  • LIMIT (카드사용한도) — NUMBER

COMMENT (댓글)

  • COMMENT_NUM (댓글번호) — NUMBER — Primary key — NOT NULL
  • PRODUCT_NUM (상품번호) — NUMBER — Foreign key → PRODUCT.PRODUCT_NUM — NOT NULL
  • ID — VARCHAR(200) — Foreign key → MEMBER.ID — NOT NULL
  • PRODUCT_JUNSU (평점) — NUMBER(3,2)
  • HIREDATE (등록날짜) — DATE
  • WRITER (작성자) — VARCHAR2(200)
  • CONTENTS (내용) — 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

Copy Of MEMBER_ROLE (CopyOf멤버 권한)

  • ID — VARCHAR2(200) — Foreign key → MEMBER.ID — NOT NULL
  • ROLE_NUM (권한번호) — NUMBER — Foreign key → Copy Of ROLE.ROLE_NUM — NOT NULL

Copy Of ROLE (CopyOf권한)

  • ROLE_NUM (권한번호) — NUMBER — Primary key — NOT NULL
  • ROLE_NAME (권한이름) — VARCHAR2(200)

DEPARTMENTS (부서 정보)

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

EMPLOYEES (사원 정보)

  • EMPLOYEES (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

INQUIRY (조회)

  • INQUIRY NUM (조회번호) — NUMBER — Primary key — NOT NULL
  • ACCOUNTNUM (계좌번호) — VARCHAR2(200) — Foreign key → OPENING_ACCOUNT.ACCOUNTNUM — NOT NULL
  • DWDATE (입출금 날짜) — DATE
  • BALANCE (잔액) — NUMBER
  • REMITTANCEACC (송금계좌) — VARCHAR2(200)
  • RECEIVEDACC (받는계좌) — VARCHAR2(200)
  • SENDERNAME (송금자명) — VARCHAR2(200)
  • DWNOTICE (입출금알림) — VARCHAR2(200)

LOAN (대출)

  • LAONNUM (대출번호) — NUMBER — Primary key — NOT NULL
  • INTEREST (대출금리) — NUMBER(2,1)
  • LOANMONEY (대출금액) — NUMBER

LOCATIONS (지역 정보)

  • LOCATION_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
  • Field5

MEMBER (회원)

  • ID — VARCHAR2(200) — Primary key — NOT NULL
  • PASSWORD (PW) — VARCHAR2(200)
  • NAME (이름) — VARCHAR2(200)
  • ADDRESS (주소) — VARCHAR2(200)
  • PHONE_NUM (전화번호) — VARCHAR2(200)
  • EMAIL (이메일) — VARCHAR2(200)

MEMBER (은행회원)

  • ID — VARCHAR2(200) — Primary key — NOT NULL
  • PW — VARCHAR2(200)
  • NAME (이름) — VARCHAR2(200)
  • ADDRESS (주소) — VARCHAR2(200)
  • PHONE (전화번호) — VARCHAR2(200)
  • EMAIL (이메일) — VARCHAR2(200)

MEMBER_ROLE (멤버 권한)

  • ID — VARCHAR2(200) — Foreign key → MEMBER.ID — NOT NULL
  • ROLL_NUM (권한번호) — NUMBER — Foreign key → ROLE.ROLL_NUM — NOT NULL

OPENING_ACCOUNT (통장개설 및 정보)

  • ACCOUNTNUM (계좌번호) — VARCHAR2(200) — Primary key — NOT NULL
  • PRODUCTNUM (통장상품번호) — NUMBER — Foreign key → BANK_PRODUCT.PRODUCTNUM — NOT NULL
  • ID — VARCHAR2(200) — Foreign key → MEMBER.ID — NOT NULL
  • ACCOUNTPW (계좌비밀번호) — NUMBER
  • HIREDATE (개설일) — DATE
  • NAME (통장주인) — VARCHAR2(200)
  • BALANCE (잔액) — NUMBER

PRODUCT (상품들)

  • PRODUCT_NUM (상품번호) — NUMBER — Primary key — NOT NULL
  • PRODUCT_NAME (상품명) — VARCHAR2(200)
  • PRODUCT_DETAIL (제품설명) — CLOB
  • PRODUCT_JUMSU (평점) — NUMBER(2,1)

PRODUCT OPTION (상품옵션)

  • OPTION_NUM (옵션번호) — NUMBER — Primary key — NOT NULL
  • PRODUCT_NUM (상품번호) — NUMBER — Foreign key → PRODUCT.PRODUCT_NUM — NOT NULL
  • OPTION_DETAIL (옵션명) — VARCHAR2(200)
  • OPTION_PRICE (옵션 가격) — NUMBER(8,2)
  • OPTION_INVENTORY (옵션 재고) — NUMBER(5)

REGIONS (대륙정보)

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

ROLE (권한)

  • ROLL_NUM (권한번호) — NUMBER — Primary key — NOT NULL
  • ROLL_NAME (권한이름) — VARCHAR2(200)

SHARES (주식)

  • SHARENUM (주식 번호) — VARCHAR2(200) — Primary key — NOT NULL
  • SHAREMONEY (보유주식금액) — NUMBER
  • CASHHELD (보유금액) — NUMBER

공지사항 (NOTICE)

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

공지사항파일 (NOTICEFILES)

  • 파일번호 (FILENUM) — NUMBER — Primary key — NOT NULL
  • 글번호 (NUM) — NUMBER — Foreign key → 공지사항.글번호 — NOT NULL
  • 파일명 (FILENAME) — VARCHAR2(200)
  • 업로드명 (ORINAME) — VARCHAR2(200)

댓글 (BANKBOOKCOMMENT)

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

상품 이미지 (BANKBOOKIMG)

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

질답게시판 (QNA)

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

질답게시판파일 (QNAFILES)

  • 파일번호 (FILENUM) — NUMBER — Primary key — NOT NULL
  • 글번호 (NUM) — NUMBER — Foreign key → 질답게시판.글번호 — NOT NULL
  • 파일명 (FILENAME) — VARCHAR2(200)
  • 업로드명 (ORINAME) — VARCHAR2(200)