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