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)