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)