VDM System
Tables (5)
Manual (사용 설명서)
- manual_id (PRIMARY KEY) — NUMBER — Primary key — NOT NULL
- product_id (FOREIGN KEY) — NUMBER — Foreign key → Product.product_id — NOT NULL
- manual_title (Field4) — VARCHAR2(100)
- file_path (Field5) — VARCHAR2(255)
- uploaded_at (Field6) — TIMESTAMP
- updated_at (Field7) — TIMESTAMP
Payment (결제 테이블)
- payment_id (PRIMARY KEY) — NUMBER — Primary key — NOT NULL
- user_id (FOREIGN KEY) — VARCHAR2(100) — Foreign key → User.user_id — NOT NULL
- product_id (FOREIGN KEY2) — NUMBER — Foreign key → Product.product_id — NOT NULL
- amount (Field5) — NUMBER
- payment_method (Field6) — VARCHAR2(50)
- payment_date (Field7) — TIMESTAMP
- status (Field8) — VARCHAR2(50)
- transaction_id (Field9) — VARCHAR2(100
Product (자판기 테이블)
- product_id (PRIMARY KEY) — NUMBER — Primary key — NOT NULL
- product_name (UNIQUE KEY) — VARCHAR2(100)
- price (Field4) — NUMBER
- quantity (Field5) — NUBMER
- model_name (Field6) — VARCHAR2(50)
- manufacturer (Field) — VARCHAR2(100)
- img_path (Field2) — VARCHAR2(255)
- created_at (Field7) — TIMESTAMP
- updated_at (Field8) — TIMESTAMP
Product_Detail (자판기 상세 정보)
- detail_id (PRIMARY KEY) — NUMBER — Primary key — NOT NULL
- product_id (FOREIGN KEY) — NUMBER — Foreign key → Product.product_id — NOT NULL
- product_name (FOREIGN KEY 2) — VARCHAR2(100)
- demensions (Field5) — VARCHAR2(200)
- sale_items (Field6) — VARCHAR2(1000)
- storage_method (Field7) — VARCHAR2(100)
- description (Field8) — CLOB
User (사용자)
- user_id (PRIMARY KEY) — VARCHAR2(100) — Primary key — NOT NULL
- email (Field3) — VARCHAR2(100)
- password (Field4) — VARCHAR2(255)
- role (Field5) — VARCHAR2(50)
- created_at (Field6) — TIMESTAMP
- updated_at (Field7) — TIMESTAMP