HR

Tables (15)

ADDRESS (배송지정보)

  • 번호 (ADDRESSNUM) — NUMBER — Primary key — NOT NULL
  • ID — VARCHAR2(200) — Foreign key → MEMBER.ID — NOT NULL
  • 주소 (ADDRESS) — VARCHAR2(200)
  • 전화번호 (ADDRESSPHONE) — VARCHAR2(200)
  • 이름 (ADDRESSNAME) — VARCHAR2(200)

COMMENTARY (댓글)

  • 댓글번호 (COMMENTNUM) — NUMBER — Primary key — NOT NULL
  • 상품번호 (PRODUCTNUM) — NUMBER — Foreign key → PRODUCT.상품번호 — NOT NULL
  • ID — VARCHAR2(200) — Foreign key → MEMBER.ID — NOT NULL
  • 평점 (COMMENTSCORE) — NUMBER(2,1)
  • 작성날짜 (COMMENTDATE) — DATE
  • 내용 (COMMANETARY) — VARCHAR2(500)

COUNTRIES (국가정보)

  • COUNTRY_ID (Key) — VARCHAR2 — Primary key — NOT NULL
  • REGION_ID (Key2) — NUMBER — Foreign key → REGIONS.REGION_ID — NOT NULL
  • COUNDTY)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
  • JOB_ID (Field6) — VARCHAR2
  • SALARY (Field7) — NUMBER
  • COMMINSION_PCT (Field8) — NUMBER
  • MANAGER_ID (Field9) — 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(200) — Primary key — NOT NULL
  • PW (비번) — VARCHAR2(200)
  • MEMBERNAME (이름) — VARCHAR2(200)
  • MEMBERPHONE (전화번호) — VARCHAR2(200)
  • EMAIL (이메일) — VARCHAR2(200)

MEMBER_ROLE (멤버권한)

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

PRODUCT (수정전상품들1)

  • Key (상품번호) — Primary key — NOT NULL
  • Field (상품명)
  • Field (옵션명)
  • Field (옵션가격)
  • Field (옵션재고)
  • Field (상세설명)
  • Field (평점)
  • Field (댓글)

PRODUCT (수정전상품들2)

  • Key (상품번호) — Primary key — NOT NULL
  • Field (상품명)
  • Field (상세설명)
  • Field (평점)
  • Field (댓글)

PRODUCT (상품들)

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

PRODUCTOPTION (상품옵션2)

  • Key (옵션번호) — Primary key — NOT NULL
  • Key (상품번호) — Foreign key → PRODUCT.Key — NOT NULL
  • Field (옵션명)
  • Field (옵션가격)
  • Field (옵션재고)

PRODUCTOPTION (상품옵션)

  • 옵션번호 (OPTIONNUM) — NUMBER — Primary key — NOT NULL
  • 상품번호 (PRODUCTNUM) — NUMBER — Foreign key → PRODUCT.상품번호 — 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)