HR

Tables (34)

ADDRESS (배송지)

  • ADDRESSNUM (배송번호) — NUMBER — Primary key — NOT NULL
  • ID (아이디) — VARCHAR2(50) — Foreign key → MEMBER.ID — NOT NULL
  • ADDRESS (주소) — VARCHAR2(100)
  • PHONE (전화번호) — VARCHAR2(50)
  • EMAIL (이메일) — VARCHAR2(50)

BANKACCOUNT (통장 개설 정보)

  • ACCOUNTNUM (계좌번호) — VARCHAR2(100) — Primary key — NOT NULL
  • ID (회원아이디) — VARCHAR2(100) — Foreign key → BANKMEMBERS.ID — NOT NULL
  • BOOKNUM (일련번호) — NUMBER — Foreign key → BANKBOOK.BOOKNUM — NOT NULL
  • ACCOUNTDATE (통장개설일) — DATE
  • ACCOUNTBALANCE (전체잔액) — NUMBER

BANKBOOK (통장상품정보)

  • BOOKNUM (일련번호) — NUMBER — Primary key — NOT NULL
  • BOOKNAME (통장이름) — VARCHAR2(100)
  • BOOKDETAIL (상세정보) — VARCHAR2(100)
  • BOOKRATE (이자율) — NUMBER(3,1)
  • BOOKSALE (판매여부) — NUMBER

BANKMEMBERS (회원정보)

  • ID (회원아이디) — VARCHAR2(100) — Primary key — NOT NULL
  • PW (비밀번호) — VARCHAR2(100)
  • NAME (이름) — VARCHAR2(100)
  • PHONE (전화번호) — VARCHAR2(100)
  • EMAIL (이메일) — VARCHAR2(100)

BANKTRADE (거래내역)

  • TRADENUM (일련번호) — NUMBER — Primary key — NOT NULL
  • ACCOUNTNUM (계좌번호) — VARCHAR2(100) — Foreign key → BANKACCOUNT.ACCOUNTNUM — NOT NULL
  • TRADEBALANCE (거래후잔액) — NUMBER
  • TRADETABLE (거래일) — DATE
  • TRADEIO (입출금구분) — NUMBER
  • TRADEAMOUNT (거래전잔액) — VARCHAR2(100)

BOARD (게시판)

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

BOARDFILE (게시판 파일)

  • 파일번호 (FILENUM) — NUMBER — Primary key — NOT NULL
  • 글번호 (NUM2) — NUMBER — Foreign key → BOARD.글번호 — NOT NULL
  • 파일명 (FILENAME) — VARCHAR2(100)
  • 오리지날이름 (ORINAME) — VARCHAR2(100)

BOARDSTACK (기술게시판테이블)

  • 글번호 (NUM) — NUMBER — Foreign key → BOARD.글번호 — NOT NULL
  • 기술번호 (STACKNUM) — NUMBER — Foreign key → STACK.기술번호 — NOT NULL

COMMENT (댓글옵션)

  • COMMENTNUM (댓글번호) — NUMBER — Primary key — NOT NULL
  • PRODUCTNUM (상품번호) — NUMBER — Foreign key → PRODUCT.PRODUCTNUM — NOT NULL
  • ID (아이디) — VARCHAR2(50) — Foreign key → MEMBER.ID — NOT NULL
  • COMMENTJUMSU (평점) — NUMBER(1,1)
  • WRITEDATE (작성날짜) — DATE
  • WRITER (작성자) — VARCHAR2(50)
  • CONTENT (내용) — CLOB

COMMENT1 (댓글옵션1)

  • COMMENTNUM (댓글번호) — NUMBER — Primary key — NOT NULL
  • PRODUCTNUM (상품번호) — NUMBER — Foreign key → PRODUCT1.PRODUCTNUM — NOT NULL
  • ID (회원아이디) — VARCHAR2(100) — Foreign key → BANKMEMBERS.ID — NOT NULL
  • COMMENTJUMSU (평점) — NUMBER(2,1)
  • WRITEDATE (작성날짜) — DATE
  • WRITER (작성자) — VARCHAR2(100)
  • CONTENT (내용) — 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

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

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
  • SALARY (Field6) — NUMBER
  • COMMISION_PCT (Field7) — NUMBER
  • MANAGER_ID (Field8) — 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

MEMBER (회원)

  • ID (아이디) — VARCHAR2(50) — Primary key — NOT NULL
  • PW (비번) — NUMBER
  • NAME (이름) — VARCHAR2(50)
  • ADDRESS (주소) — VARCHAR2(100)
  • PHONE (전화번호) — VARCHAR2(50)
  • EMAIL (이메일) — VARCHAR2(50)

MEMBER (회원테이블)

  • USERNAME (회원아이디) — VARCHAR(100) — Primary key — NOT NULL
  • PASSWORD (비밀번호) — VARCHAR2(100)
  • NAME (이름) — VARCHAR2(100)
  • EMAIL (이메일) — VARCHAR2(100)
  • BIRTH (생일) — VARCHAR2(100)
  • ENABLED (휴먼계정 유무) — VARCHAR2(100)
  • LASTTIME (마지막로그인) — DATETIME

MEMBER1_ROLE1 (멤버권한1)

  • ID (회원아이디) — VARCHAR2(100) — Foreign key → BANKMEMBERS.ID — NOT NULL
  • ROLENUM (권한번호) — NUMBER — Foreign key → ROLE1.ROLENUM — NOT NULL

MEMBER_ROLE (멤버권한)

  • ID (아이디) — VARCHAR2(50) — Foreign key → MEMBER.ID — NOT NULL
  • ROLENUM (권한번호) — NUMBER — Foreign key → ROLE.ROLENUM — NOT NULL

MEMBER_ROLE (회원권한테이블)

  • USERNAME (회원아이디) — VARCHAR(100) — Foreign key → MEMBER.USERNAME — NOT NULL
  • NUM (권한번호) — NUMBER — Foreign key → ROLE.NUM — NOT NULL

PRODUCT (상품들)

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

PRODUCT1 (상품들1)

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

PRODUCTOPTION (상품옵션)

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

PRODUCTOPTION1 (상품옵션1)

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

REGIONS (대륙정보)

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

ROLE (권한테이블)

  • NUM (권한번호) — NUMBER — Primary key — NOT NULL
  • ROLENAME (권한이름) — VARCHAR(100)

ROLE (권한)

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

ROLE1 (권한1)

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

STACK (기술)

  • 기술번호 (STACKNUM) — NUMBER — Primary key — NOT NULL
  • 기술 (STACK) — VARCHAR(100)

공지사항 (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
  • 일련번호 (BOOKNUM) — NUMBER — Foreign key → BANKBOOK.BOOKNUM — NOT NULL
  • 댓글내용 (CONTENTS) — VARCHAR2(4000)
  • 작성일 (REGDATE) — DATE
  • 작성자 (WRITER) — VARCHAR2(200)

상품이미지 (BANKBOOKIMG)

  • 파일번호 (FILENUM) — NUMBER — Primary key — NOT NULL
  • BOOKNUM (일련번호) — NUMBER — Foreign key → BANKBOOK.BOOKNUM — 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)