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)