HR
Tables (21)
ACCOUNT (계좌)
- SERIALNUM (고유 번호) — NUMBER — Primary key — NOT NULL
- MEMBERID (ID) — VARCHAR2(20) — Foreign key → MEMBER.MEMBERID — NOT NULL
- BANKBOOKNUM (통장 상품 번호) — NUMBER — Foreign key → BANKBOOK.BANKBOOKNUM — NOT NULL
- ACCOUNTNUM (계좌 번호) — VARCHAR2(200)
- OPENDATE (개설일) — DATE
- BALANCE (잔액) — NUMBER
BANKBOOK (통장 상품)
- BANKBOOKNUM (통장 상품 번호) — NUMBER — Primary key — NOT NULL
- BANKBOOKNAME (통장 상품 이름) — VARCHAR2(200)
- INTERESTRATE (이자율) — NUMBER(3,1)
- BANKBOOKDETAIL (상세 내용) — CLOB
- SALECHECK (판매 여부) — NUMBER(1)
BANKBOOKCOMMENTS (통장 상품 댓글)
- NUM (댓글 번호) — NUMBER — Primary key — NOT NULL
- BANKBOOKNUM (통장 상품 번호) — NUMBER — Foreign key → BANKBOOK.BANKBOOKNUM — NOT NULL
- CONTENTS (댓글 내용) — VARCHAR2(4000)
- REGDATE (작성일) — DATE
- WRITER (작성자) — VARCHAR2(200)
BANKBOOKIMG (상품 이미지)
- FILENUM (파일 번호) — NUMBER — Primary key — NOT NULL
- BANKBOOKNUM (통장 상품 번호) — NUMBER — Foreign key → BANKBOOK.BANKBOOKNUM — NOT NULL
- FILENAME (저장된 파일명) — VARCHAR2(400)
- ORINAME (업로드 시 파일명) — VARCHAR2(400)
BANKING (은행 업무)
- SERIALNUM (고유 번호) — NUMBER — Foreign key → ACCOUNT.SERIALNUM — NOT NULL
- MEMBERID (ID) — VARCHAR2(20) — Foreign key → ACCOUNT.MEMBERID — NOT NULL
- BANKBOOKNUM (통장 상품 번호) — NUMBER — Foreign key → ACCOUNT.BANKBOOKNUM — NOT NULL
- BANKINGDATE (입출금 일자) — DATE
- BANKINGCHECK (입출금 여부) — NUMBER(1)
- TRANSFER (이체 내역) — NUMBER
COMMENTS (댓글)
- COMMNETNUM (댓글 번호) — NUMBER — Primary key — NOT NULL
- PRODUCTNUM (상품 번호) — NUMBER — Foreign key → PRODUCT.PRODUCTNUM — NOT NULL
- COMMENTID (작성자) — VARCHAR2 — Foreign key → MEMBER.MEMBERID — NOT NULL
- COMMENTRATING (평점) — NUMBER — NOT NULL
- COMMENTUPLOADDATE (등록 날짜) — DATE — NOT NULL
- COMMNETDETAIL (내용) — 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
DELIVERY (배송지)
- DELIVERYNUM (배송 번호) — Primary key — NOT NULL
- DELIVERYID (ID) — VARCHAR2(20) — Foreign key → MEMBER.MEMBERID — NOT NULL
- DELIVERYADDRESS (주소) — VARCHAR2(200)
- DELIVERYPHONE (전화 번호) — VARCHAR2(50)
- DELIVERYNAME (이름) — VARCHAR2(20)
DEPARTMENTS (부서 정보)
- DEPARTMENT_ID (Key) — NUMBER — Primary key — NOT NULL
- LOCATIONS_ID (Key2) — NUMBER — Foreign key → LOCATIONS.LOCATIONS_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
LOCATIONS (지역 정보)
- LOCATIONS_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 (회원)
- MEMBERID (ID) — VARCHAR2(20) — Primary key — NOT NULL
- MEMBERPW (PW) — VARCHAR2(20)
- MEMBERNAME (이름) — VARCHAR2(20)
- MEMBERADDRESS (주소) — VARCHAR2(200)
- MEMBERPHONE (전화 번호) — VARCHAR2(50)
- MEMBEREMAIL (EMAIL) — VARCHAR2(50)
MEMBER_ROLE (멤버 권한)
- MEMBERID (ID) — VARCHAR2(20) — Foreign key → MEMBER.MEMBERID — NOT NULL
- ROLENUM (권한 번호) — NUMBER — Foreign key → ROLE.ROLENUM — NOT NULL
NOTICE (공지사항)
- NUM (글 번호) — NUMBER — Primary key — NOT NULL
- TITLE (글 제목) — VARCHAR2(200)
- CONTENTS (글 내용) — CLOB
- WRITER (작성자) — VARHCAR2(200)
- REGDATE (작성일) — DATE
- HIT (조회수) — NUMBER
NOTICEFILES (공지사항 파일)
- FILENUM (파일 번호) — NUMBER — Primary key — NOT NULL
- NUM (글 번호) — NUMBER — Foreign key → NOTICE.NUM — NOT NULL
- FILENAME (파일 이름) — VARCHAR2(200)
- ORINAME (업로드명) — VARCHAR2(200)
PRODUCT (상품들)
- PRODUCTNUM (상품 번호) — NUMBER — Primary key — NOT NULL
- PRODUCTNAME (상품명) — VARCHAR(200) — NOT NULL
- PRODUCTDETAIL (제품 설명) — CLOB — NOT NULL
- PRODUCTRATING (평점) — NUMBER(2, 1) — NOT NULL
PRODUCT OPTION (상품 옵션)
- OPTIONNUM (옵션 번호) — NUMBER — Primary key — NOT NULL
- PRODUCTNUM (상품 번호) — NUMBER — Foreign key → PRODUCT.PRODUCTNUM — NOT NULL
- OPTIONNAME (옵션명) — VARCHAR2(50) — NOT NULL
- OPTIONPRICE (옵션 가격) — NUMBER — NOT NULL
- OPTIONSTOCK (옵션 재고) — NUMBER — NOT NULL
QNA (질문/답변게시판)
- NUM (글 번호) — NUMBER — Primary key — NOT NULL
- TITLE (글 제목) — VARCHAR2(200)
- CONTENTS (글 내용) — CLOB
- WRITER (작성자) — VARHCAR2(200)
- REGDATE (작성일) — DATE
- HIT (조회수) — NUMBER
- REF (Field) — NUMBER
- STEP (Field2) — NUMBER
- DEPTH (Field3) — NUMBER
QNAFILES (질문/답변게시판 파일)
- FILENUM (파일 번호) — NUMBER — Primary key — NOT NULL
- NUM (글 번호) — NUMBER — Foreign key → QNA.NUM — NOT NULL
- FILENAME (파일 이름) — VARCHAR2(200)
- ORINAME (업로드명) — VARCHAR2(200)
REGIONS (대륙 정보)
- REGION_ID (Key) — NUMBER — Primary key — NOT NULL
- REGION_NAME (Field) — VARCHAR2
ROLE (권한)
- ROLENUM (권한 번호) — NUMBER — Primary key — NOT NULL
- ROLENAME (권한 이름) — VARCHAR2(20)