파이널 프로젝트-글로벌
테이블 (5)
FINANCIAL_RECORD
- recordNo — NUMBER — 기본 키 — NOT NULL
- date — DATE — NOT NULL
- total_sales — NUMBER(12, 2) — NOT NULL
- total_expenses — NUMBER(12, 2) — NOT NULL
- profit — NUMBER(12, 2)
ORDER
- orderNo — NUMBER — 기본 키 — NOT NULL
- userNo (KeyuserNo) — NUMBER — 외래 키 → USER.userNo — NOT NULL
- orderDate — DATE
- totalAmount — NUMBER(12, 2) — NOT NULL
- status — VARCHAR2(20)
ORDER_DETAIL
- orderNo (orderNo2) — NUMBER — 외래 키 → ORDER.orderNo — NOT NULL
- userNo (KeyuserNo) — NUMBER — 외래 키 → ORDER.userNo — NOT NULL
- orderDetailNo — NUMBER
- productNo — NUMBER
- quantity — NUMBER — NOT NULL
- subtotal — NUMBER(12, 2) — NOT NULL
PRODUCT
- productNo — NUMBER — 기본 키 — NOT NULL
- userNo (KeyuserNo) — NUMBER — 외래 키 → USER.userNo — NOT NULL
- orderNo (orderNo2) — NUMBER — 외래 키 → ORDER_DETAIL.orderNo — NOT NULL
- userNo (KeyuserNo2) — NUMBER — 외래 키 → ORDER_DETAIL.userNo — NOT NULL
- name — VARCHAR2(100) — NOT NULL
- category — VARCHAR2(50)
- price — NUMBER(10, 2) — NOT NULL
- stock — NUMBER — NOT NULL
- description — CLOB
- image_path — VARCHAR2(255)
USER
- userNo (KeyuserNo) — NUMBER — 기본 키 — NOT NULL
- userId — VARCHAR2(50) — NOT NULL
- username — VARCHAR2(50) — NOT NULL
- password — VARCHAR2(100) — NOT NULL
- email — VARCHAR2(100)
- phone — VARCHAR2(15)
- role — VARCHAR2(10)