HR
Tables (13)
ADDRESS (배송지)
- ADDRESSNUM (배송번호) — NUMBER — Primary key — NOT NULL
- MEMBERID (ID) — VARCHAR2(100) — Foreign key → MEMBER.MEMBERID — NOT NULL
- ADDRESSDETAIL (주소) — VARCHAR2(300)
- ADDRESSPHONE (받는전화번호) — VARCHAR2(50)
- ADDRESSNAME (받는이름) — VARCHAR2(50)
BASCKET (장바구니)
- BASCKETNUM (장바구니번호) — NUMBER — Primary key — NOT NULL
- PRODUCTIONNUM (옵션번호) — NUMBER — Foreign key → PRODUCTION.PRODUCTIONNUM — NOT NULL
- PRODUCTNUM (상품번호) — NUMBER — Foreign key → PRODUCTION.PRODUCTNUM — NOT NULL
- Field (수량) — NUMBER
- Field (총가격) — NUMBER
COMMENT (댓글)
- COMMENTNUM (댓글번호) — NUMBER — Primary key — NOT NULL
- PRODUCTNUM (상품번호) — NUMBER — Foreign key → PRODUCT.PRODUCTNUM — NOT NULL
- MEMBERID (ID) — VARCHAR2(100) — Foreign key → MEMBER.MEMBERID — NOT NULL
- COMMENTDETAIL (댓글내용) — VARCHAR2(200)
- COMMENTDATE (등록날짜) — DATE
COUNTRIES (나라정보)
- COUNTRY_ID (Key) — VARCHAR2 — Primary key — NOT NULL
- REGION_ID (Key2) — NUMBER — Foreign key → REGIONS.REGION_ID — NOT NULL
- COUNTRY_NAME (Field) — VARCHAR2
DEPARTMENTS (Untitled2)
- 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 (Untitled3)
- 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 (지역정보)
- 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 (회원)
- MEMBERID (ID) — VARCHAR2(100) — Primary key — NOT NULL
- BASCKETNUM (장바구니번호) — NUMBER — Foreign key → BASCKET.BASCKETNUM — NOT NULL
- MEMBERPW (PW) — VARCHAR2(100)
- MEMBERNAME (이름) — VARCHAR2(50)
- MEMBERPHONE (전화번호) — VARCHAR2(50)
- MEMBEREMAIL (이메일) — VARCHAR2(100)
- MEMBERADDRESS (주소) — VARCHAR2(200)
MEMBER_ROLE (멤버권한)
- ID — VARCHAR2(100) — Foreign key → MEMBER.MEMBERID — NOT NULL
- ROLENUM (권한번호) — NUMBER — Foreign key → ROLE.ROLENUM — NOT NULL
PRODUCT (상품들)
- PRODUCTNUM (상품번호) — NUMBER — Primary key — NOT NULL
- PRODUCTNAME (상품명) — VARCHAR2(200)
- PRODUCTDETAIL (제품설명) — CLOB
- PRODUCTSCORE (평점) — NUMBER(2,1)
PRODUCTION (상품옵션)
- PRODUCTIONNUM (옵션번호) — NUMBER — Primary key — NOT NULL
- PRODUCTNUM (상품번호) — NUMBER — Foreign key → PRODUCT.PRODUCTNUM — NOT NULL
- PRODUCTIONNAME (옵션명) — VARCHAR2(200)
- PRODUCTIONPRICE (옵션가격) — NUMBER
- PRODUCTIONSTOCK (옵션재고) — NUMBER
REGIONS (대륙정보)
- REGION_ID (Key) — NUMBER — Primary key — NOT NULL
- REGION_ NAME (Field) — VARCHAR2
ROLE (권한)
- ROLENUM (권한번호) — NUMBER — Primary key — NOT NULL
- ROLENAME (권한이름) — VARCHAR2(200)