HR

Tables (14)

ADDRESS (배송지)

  • POSTNUM (배송번호) — NUMBER(50) — Primary key — NOT NULL
  • ID — VARCHAR2(200) — Foreign key → MEMBER.ID — NOT NULL
  • ADDRESSNAME (이름) — VARCHAR2(200)
  • FROMADDRESS (받는사람) — VARCHAR2(200)

COMMENT (댓글)

  • REPLENUM (댓글번호) — NUMBER(50) — Primary key — NOT NULL
  • ITEMNUM (상품번호) — NUMBER(50) — Foreign key → PRODUCT.ITEMNUM — NOT NULL
  • ID — VARCHAR2(20) — Foreign key → MEMBER.ID — NOT NULL
  • PRODUCTJUMSU (평점) — NUMBER(2,1)
  • COMMENT_DATE (등록날짜) — DATE
  • COMMENTID (작성자) — VARCHAR2(200)
  • SUMMURY (내용) — CLOB

COUNTRIES (나라정보)

  • COUNTRY_ID (Key) — VARCHAR2 — Primary key — NOT NULL
  • RIGION_ID (Key2) — NUMBER — Foreign key → REGIONS.REIGION_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
  • Key3 — Foreign key → LOCATIONS.Key3 — NOT NULL
  • DEPARTMENT_NAME (Field) — VARCHAR2
  • MANAGER_ID (Field2) — NUMBER

EMPLOYEES (Untitled2)

  • EMPLOYEE_ID (Key) — NUMBER — Primary key — NOT NULL
  • DEPARTMENT_ID (Key2) — NUMBER — Foreign key → DEPARTMENTS.DEPARTMENT_ID — NOT NULL
  • Key3 — Foreign key → DEPARTMENTS.Key3 — NOT NULL
  • FIRST_NAME (Field) — VARCHAR2
  • LAST_NAME (Field2) — VARCHAR2
  • EMAIL (Field3) — VARCHAR2
  • PHONE_NUMBER (Field4) — NUMBER
  • HIRE_DATE (Field5) — DATE
  • JOB_ID (Field6) — VARCHAR2
  • SALARY (Field7) — NUMBER
  • COMMISSION_PCT (Field8) — NUMBER
  • MANAGER_ID (Field9) — NUMBER

JOBS (Untitled4)

  • JOB_ID (Key) — VARCHAR2 — Primary key — NOT NULL
  • JOB_TITLE (Field) — VARCHAR2
  • MIN_SALARY (Field2) — NUMBER
  • MAX_SALART (Field3) — NUMBER

JOB_HISTORY (Untitled3)

  • START_DATE (Key) — DATE — Primary key — NOT NULL
  • END_DATE (Field) — DATE
  • JOB_ID (Field2) — VARCHAR2
  • DEPARTMENT_ID (Field3) — NUMBER
  • Field4

LOCATIONS (Untitled)

  • LOCATION_ID (Key) — NUMBER — Primary key — NOT NULL
  • Key3 — 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(20) — Primary key — NOT NULL
  • PW (비번) — VARCHAR2(100)
  • NAME (이름) — VARCHAR2(20)
  • ADDRESS (주소) — VARCHAR2(200)
  • PHONENUMBER (전화번호) — VARCHAR2(15)
  • EMAIL (이메일) — VARCHAR2(30)

MEMBER_ROLE (멤버권한)

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

PRODUCT (상품들)

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

PRODUCTOPTION (상품옵션)

  • OPTIONNUM (옵션번호) — NUMBER(50) — Primary key — NOT NULL
  • ITEMNUM (상품번호) — NUMBER(50) — Foreign key → PRODUCT.ITEMNUM — NOT NULL
  • OPTIONNAME (옵션명) — VARCHAR2(200)
  • OPTIONM (옵션가격) — NUMBER(20)

REGIONS (대륙정보)

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

ROLE (권한)

  • ROLENUM (권한번호) — NUMBER — Primary key — NOT NULL
  • ROLENAME (Field) — VARCHAR2(200)