HR

Tables (30)

ACCOUNT

  • ACCOUNTNUMBER (계좌번호) — NUMBER — Primary key — NOT NULL
  • BOOKNUMBER — NUMBER — Foreign key → BANKBOOK.BOOKNUMBER — NOT NULL
  • BOOKNUMBER (Field) — NUMBER
  • ID (아이디) — VARCHAR(200)
  • ACCOUNTDATE (개설일) — DATE
  • ACCOUNTBALANCE (전체잔액) — NUMBER

ADDRESS (배송지)

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

BANK (은행)

  • 은행 번호 (BANK_NUM) — NUMBER — Primary key — NOT NULL
  • 회원 번호 (MEMBER_NUM) — NUMBER
  • 상품 번호 (BANKBOOK_NUM) — NUMBER

BANKBOOK

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

BANKBOOK (통장)

  • 계좌번호 (BANKBOOK_ACCOUNT) — VARCHAR(100) — Primary key — NOT NULL
  • 상품명 (BANKBOOK_NAME) — VARCHAR(200) — Foreign key → BANKBOOK_INFO.상품 번호 — NOT NULL
  • 회원 아이디 (MEMBER_ID) — VARCHAR2(100) — Foreign key → MEMBER2.회원 아이디 — NOT NULL
  • 개설 날짜 (BANKBOOK_DATE) — DATE
  • 잔액 (BANKBOOK_BALANCE) — NUMBER

BANKBOOK_FUNTION (통장기능)

  • 기능 번호 (FUNTION_NUM) — NUMBER — Primary key — NOT NULL
  • 계좌번호 (BANKBOOK_ACCOUNT) — VARCHAR(100) — Foreign key → BANKBOOK.계좌번호 — NOT NULL
  • 입금 (BANKBOOK_INPUT) — NUMBER
  • 출금 (BANKBOOK_OUTPUT) — NUMBER

BANKBOOK_INFO (상품 정보)

  • 상품명 (BANKBOOK_NAME) — VARCHAR(200) — Primary key — NOT NULL
  • 상품 번호 (BANKBOOK_NUM) — NUMBER — Foreign key → BANK.은행 번호 — NOT NULL
  • 이자율 (BANKBOOK_RATE) — NUMBER(3,2)
  • 상세 정보 (BANKBOOK_DETAIL) — CLOB
  • 판매 여부 (BANKBOOK_SALEOX) — VARCHAR(100)

COMMENTS (댓글)

  • COMMENTNUM (댓글번호) — NUMBER — Primary key — NOT NULL
  • PRODUCTNUM (상품번호) — NUMBER — Foreign key → PRODUCT.PRODUCTNUM — NOT NULL
  • ID (아이디) — VARCHAR2(100) — Foreign key → MEMBER.ID — NOT NULL
  • PRODUCTJUMSU (평점) — NUMBER(2,1)
  • DATE (등록날짜) — SYSDATE
  • TEMPLATE (작성자) — VARCHAR2(100)
  • BODY (내용) — 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
  • REGION_ID (Field2) — NUMBER

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
  • JOB_ID (Field6) — VARCHAR2
  • SALARY (Field7) — NUMBER
  • COMMISSION_PCT (Field8) — NUMBER
  • MANAGER_ID (Field9) — NUMBER

INPUT_SELECT (입금)

  • 입금 번호 (INPUT_NUM) — NUMBER — Primary key — NOT NULL
  • 기능 번호 (FUNTION_NUM) — NUMBER — Foreign key → BANKBOOK_FUNTION.기능 번호 — NOT NULL
  • 입금 금액 (INPUT_PRICE) — NUMBER
  • 입금한 사람 (INPUT_USER) — VARCHAR2(100)
  • 입금한 날짜 (INPUT_DATE) — DATE

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(100) — Primary key — NOT NULL
  • PW (패스워드) — VARCHAR2(200)
  • NAME (이름) — VARCHAR2(100)
  • ADDRESS (주소) — VARCHAR2(200)
  • PHONE (전화번호) — VARCHAR2(100)
  • EMAIL (이메일) — VARCHAR2(200)

MEMBER2 (회원)

  • 회원 아이디 (MEMBER_ID) — VARCHAR2(100) — Primary key — NOT NULL
  • 회원 번호 (MEMBER_NUM) — NUMBER — Foreign key → BANK.은행 번호 — NOT NULL
  • 회원 비밀번호 (MEMBER_PW) — VARCHAR2(100)
  • 회원 이름 (MEMBER_NAME) — VARCHAR2(100)
  • 회원 주소 (MEMBER_ADDRESS) — VARCHAR2(100)
  • 회원 전화번호 (MEMBER_PHONE) — VARCHAR2(100)
  • 회원 이메일 (MEMBER_EMAIL) — VARCHAR2(100)

MEMBER2_ROLE (멤버 권한)

  • 권한 번호 (ROLE_NUM) — NUMBER — Foreign key → ROLE2.권한 번호 — NOT NULL
  • 회원 아이디 (MEMBER_ID) — VARCHAR2(100) — Foreign key → MEMBER2.회원 아이디 — NOT NULL

MEMBER_ROLE (멤버권한)

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

OUTPUT_SELECT (출금 조회)

  • 출금 번호 (OUTPUT_NUM) — NUMBER — Primary key — NOT NULL
  • 기능 번호 (FUNTION_NUM) — NUMBER — Foreign key → BANKBOOK_FUNTION.기능 번호 — NOT NULL
  • 출금 금액 (OUTPUT_PRICE) — NUMBER
  • 출금한 사람 (OUTPUT_USER) — VARCHAR2(100)
  • 출금한 날짜 (OUTPUT_DATE) — DATE

PRODUCT (상품들)

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

PRODUCTOPTION (상품옵션)

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

REGIONS (대륙정보)

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

ROLE (권한)

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

ROLE2 (권한2)

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

공지사항 (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)

트레이드 (TRADE)

  • TRADENUM — NUMBER — Primary key — NOT NULL
  • ACCOUNTNUMBER (계좌번호) — NUMBER — Foreign key → ACCOUNT.ACCOUNTNUMBER — NOT NULL
  • TRADEDATE — DATE
  • TRADEAMOUNT — NUMBER
  • TRADEBALANCE — NUMBER
  • TRADEIO — NUMBER(1)