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)