HR

Tables (16)

ADDRESS (배송지)

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

BANK_PRODUCT (통장상품)

  • PRODUCTNUM (통장상품번호) — NUMBER — Primary key — NOT NULL
  • INTEREST (이자율) — NUMBER(2,1)
  • PRODUCTNAME (삼품이름) — VARCHAR2(200)
  • PRODUCTOPTION (상세내용) — VARCHAR2(200)
  • PRODUCTSELL (판매여부) — VARCHAR2(200)

COMMENT (댓글)

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

  • DEPARTMENT_ID (Key) — NUMBER — Primary key — NOT NULL
  • LOCATION_ID (Key2) — NUMBER — Foreign key → LOCATIONS.LOCATION_ID — NOT NULL
  • COUNTRY_ID (Key22) — VARCHAR2 — Foreign key → LOCATIONS.COUNTRY_ID — NOT NULL
  • DEPARTMENT_NAME (Field) — VARCHAR2
  • MANAGER_ID (Field2) — NUMBER
  • LOCATION_ID (Field3) — NUMBER

EMPLOYEES (Untitled3)

  • EMPLOYEE_ID (Key) — NUMBER — Primary key — NOT NULL
  • COUNTRY_ID (Key222) — VARCHAR2 — Foreign key → DEPARTMENTS.COUNTRY_ID — NOT NULL
  • DEPARTMENT_ID (Key2) — NUMBER — Foreign key → DEPARTMENTS.DEPARTMENT_ID — NOT NULL
  • LOCATION_ID (Key22) — NUMBER — Foreign key → DEPARTMENTS.LOCATION_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
  • DEPARTMENT_ID (Field10) — NUMBER

INQUIRY (조회)

  • INQUIRYNUM (조회번호) — NUMBER — Primary key — NOT NULL
  • ACCOUNTNUM (계좌번호) — VARCHAR2(200) — Foreign key → OPENING_ACCOUNT.ACCOUNTNUM — NOT NULL
  • DWDATE (입출금날짜) — DATE
  • BALANCE (잔액) — NUMBER
  • REMIITTANCEACC (송금계좌) — VARCHAR2(200)
  • RECEIVEDACC (받은계좌) — VARCHAR2(200)
  • SENDERNAME (송금자명) — VARCHAR2(200)

LOCATIONS (Untitled)

  • 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
  • PW (비번) — VARCHAR2(200)
  • MEMBER_NAME (이름) — VARCHAR2(200)
  • M_ADDRESS (주소) — CLOB
  • PHONE (전화번호) — VARCHAR2(200)
  • EMAIL (이메일) — VARCHAR2(200)

MEMBER (회원1)

  • ID (아이디) — VARCHAR2(200) — Primary key — NOT NULL
  • PW — VARCHAR2(200)
  • NAME (이름) — VARCHAR2(200)
  • ADDRESS (주소) — VARCHAR2(200)
  • PHONENUM (전화번호) — VARCHAR2(200)
  • EMAIL (이메일) — VARCHAR2(200)

MEMBER_ROLE (멤버권한)

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

OPENING_ACCOUNT (통장개설)

  • ACCOUNTNUM (계좌번호) — VARCHACR2(200) — Primary key — NOT NULL
  • PRODUCTNUM (통장상품번호) — NUMBER — Foreign key → BANK_PRODUCT.PRODUCTNUM — NOT NULL
  • ID (아이디) — VARCHAR2(200) — Foreign key → MEMBER.ID — NOT NULL
  • HIREDATE (개설일) — DATE
  • NAME (통장주인) — VARCHAR2(200)
  • BALANCE (액수) — NUMBER
  • ACCOUNTPW (계좌비밀번호) — NUMBER — NOT NULL

PRODUCT (상품들)

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

PRODUCTOPTION (상품옵션)

  • OPTION_NUM (옵션번호) — NUMBER — Primary key — NOT NULL
  • PRODUCTNUM (상품번호) — VARCHAR2(200) — Foreign key → PRODUCT.PRODUCTNUM — NOT NULL
  • OPTION_NAME (옵션명) — VARCHAR2(200)
  • OPTION_PRICE (옵션가격) — NUMBER
  • OPTION_JAGO (옵션재고) — NUMBER

REGIONS (대륙정보)

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

ROLE (권한)

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