HR
Tables (16)
ADDRESS (배송지)
- ADDRESS_NUM (배송번호) — NUMBER — Primary key — NOT NULL
- ID (아이디) — VARCHAR2(200) — Foreign key → MEMBER.ID — NOT NULL
- ADDRESS (주소) — VARCHAR2(200)
- A_PHONE (전화번호) — NUMBER
- A_NAME (이름) — VARCHAR2(200)
BANK_PRODUCT (통장상품)
- PRODUCTNUM (통장상품번호) — NUMBER — Primary key — NOT NULL
- INTEREST (이자율) — NUMBER(2,1)
- PRODUCTNAME (삼품이름) — VARCHAR2(200)
- PRODUCTOPTION (상세내용) — VARCHAR2(200)
- PRODUCTSELL (판매여부) — VARCHAR2(200)
COMMENT (댓글)
- COMMENTNUM (댓글번호) — NUMBER — Primary key — NOT NULL
- PRODUCTNUM (상품번호) — VARCHAR2(200) — Foreign key → PRODUCT.PRODUCTNUM — NOT NULL
- ID (아이디) — VARCHAR2(200) — Foreign key → MEMBER.ID — NOT NULL
- PRODUCTJUMSU (평점) — NUMBER(2,1)
- REGISTRATIONDATE (등록날짜) — DATE
- NAME (작성자) — VARCHAR2(200)
- COMMENTCONTENT (내용) — CLOB
COUNTRIES (나라정보)
- COUNTRY_ID (Key) — VARCHAR2 — Primary key — NOT NULL
- REGION_ID (Key2) — NUMBER — Foreign key → REGIONS.REGION_ID — NOT NULL
- COUNTRY_NAME (Field) — VARCHAR2
- REGION_ID (Field2) — NUMBER
DEPARTMENTS (Untitled2)
- DEPARTMENT_ID (Key) — NUMBER — Primary key — NOT NULL
- LOCATION_ID (Key2) — NUMBER — Foreign key → LOCATIONS.LOCATION_ID — NOT NULL
- COUNTRY_ID (Key22) — VARCHAR2 — Foreign key → LOCATIONS.COUNTRY_ID — NOT NULL
- DEPARTMENT_NAME (Field) — VARCHAR2
- MANAGER_ID (Field2) — NUMBER
- LOCATION_ID (Field3) — NUMBER
EMPLOYEES (Untitled3)
- EMPLOYEE_ID (Key) — NUMBER — Primary key — NOT NULL
- COUNTRY_ID (Key222) — VARCHAR2 — Foreign key → DEPARTMENTS.COUNTRY_ID — NOT NULL
- DEPARTMENT_ID (Key2) — NUMBER — Foreign key → DEPARTMENTS.DEPARTMENT_ID — NOT NULL
- LOCATION_ID (Key22) — NUMBER — Foreign key → DEPARTMENTS.LOCATION_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
- DEPARTMENT_ID (Field10) — NUMBER
INQUIRY (조회)
- INQUIRYNUM (조회번호) — NUMBER — Primary key — NOT NULL
- ACCOUNTNUM (계좌번호) — VARCHAR2(200) — Foreign key → OPENING_ACCOUNT.ACCOUNTNUM — NOT NULL
- DWDATE (입출금날짜) — DATE
- BALANCE (잔액) — NUMBER
- REMIITTANCEACC (송금계좌) — VARCHAR2(200)
- RECEIVEDACC (받은계좌) — VARCHAR2(200)
- SENDERNAME (송금자명) — VARCHAR2(200)
LOCATIONS (Untitled)
- 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
- Field5
MEMBER (회원)
- ID (아이디) — VARCHAR2(200) — Primary key — NOT NULL
- PW (비번) — VARCHAR2(200)
- MEMBER_NAME (이름) — VARCHAR2(200)
- M_ADDRESS (주소) — CLOB
- PHONE (전화번호) — VARCHAR2(200)
- EMAIL (이메일) — VARCHAR2(200)
MEMBER (회원1)
- ID (아이디) — VARCHAR2(200) — Primary key — NOT NULL
- PW — VARCHAR2(200)
- NAME (이름) — VARCHAR2(200)
- ADDRESS (주소) — VARCHAR2(200)
- PHONENUM (전화번호) — VARCHAR2(200)
- EMAIL (이메일) — VARCHAR2(200)
MEMBER_ROLE (멤버권한)
- ID (아이디) — VARCHAR2(200) — Foreign key → MEMBER.ID — NOT NULL
- ROLE_NUM (권한번호) — NUMBER — Foreign key → ROLE.ROLE_NUM — NOT NULL
OPENING_ACCOUNT (통장개설)
- ACCOUNTNUM (계좌번호) — VARCHACR2(200) — Primary key — NOT NULL
- PRODUCTNUM (통장상품번호) — NUMBER — Foreign key → BANK_PRODUCT.PRODUCTNUM — NOT NULL
- ID (아이디) — VARCHAR2(200) — Foreign key → MEMBER.ID — NOT NULL
- HIREDATE (개설일) — DATE
- NAME (통장주인) — VARCHAR2(200)
- BALANCE (액수) — NUMBER
- ACCOUNTPW (계좌비밀번호) — NUMBER — NOT NULL
PRODUCT (상품들)
- PRODUCTNUM (상품번호) — NUMBER — Primary key — NOT NULL
- PRODUCTNAME (상품명) — VARCHAR2(200)
- PRODUCTDETAIL (제품설명) — CLOB
- PRODUCTJUMSU (평점) — NUMBER(2,1)
PRODUCTOPTION (상품옵션)
- OPTION_NUM (옵션번호) — NUMBER — Primary key — NOT NULL
- PRODUCTNUM (상품번호) — VARCHAR2(200) — Foreign key → PRODUCT.PRODUCTNUM — NOT NULL
- OPTION_NAME (옵션명) — VARCHAR2(200)
- OPTION_PRICE (옵션가격) — NUMBER
- OPTION_JAGO (옵션재고) — NUMBER
REGIONS (대륙정보)
- REGION_ID (Key) — NUMBER — Primary key — NOT NULL
- REGION_NAME (Field) — VARCHAR2
ROLE (권한)
- ROLE_NUM (권한번호) — NUMBER — Primary key — NOT NULL
- ROLE_NAME (권한이름) — VARCHAR2(200)