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)