glory82

Tables (7)

AdminUser

  • AdminID — SERIAL — Primary key — NOT NULL
  • Username — VARCHAR(50)
  • Password — VARCHAR(100)
  • Role — VARCHAR(20)
  • LastLogin — TIMESTAMP

AuditLog (CopyOfAdminUser)

  • AuditID — SERIAL — Primary key — NOT NULL
  • AdminID — SERIAL — Foreign key → AdminUser.AdminID — NOT NULL
  • Action — VARCHAR(20)
  • TableName — VARCHAR(20)
  • RecordID — INT
  • ActionDate — DATE

Customer

  • CustomerID — SERIAL — Primary key — NOT NULL
  • Name — VARCHAR(100)
  • Email — VARCHAR(100)
  • PhoneNumber — VARCHAR(20)
  • Address — TEXT
  • RegistrationDate — DATE

Item

  • ItemID — SERIAL — Primary key — NOT NULL
  • ItemName — VARCHAR(100)
  • Category — VARCHAR(50)
  • Description — TEXT
  • UnitPrice — DECIMAL(10, 2)
  • SellPrice — DECIMAL(10, 2)
  • StockQuantity — INT

Order

  • OrderID — SERIAL — Primary key — NOT NULL
  • CustomerID — SERIAL — Foreign key → Customer.CustomerID — NOT NULL
  • OrderDate — DATE
  • TotalAmount — DECIMAL(10, 2)
  • Status — VARCHAR(20)
  • IsPrepaid — BOOLEAN
  • PrepaidAmount — DECIMAL(10,2)
  • OutstandingAmount — DECIMAL(10,20)

OrderDetails

  • OrderDetailID — SERIAL — Primary key — NOT NULL
  • OrderID — SERIAL — Foreign key → Order.OrderID — NOT NULL
  • ItemID — SERIAL — Foreign key → Item.ItemID — NOT NULL
  • Quantity — INT
  • UnitPrice — DECIMAL(10, 2)
  • TotalPrice — DECIMAL(10, 2)

Payment

  • PaymentID — SERIAL — Primary key — NOT NULL
  • OrderID — SERIAL — Foreign key → Order.OrderID — NOT NULL
  • PaymentDate — DATE
  • PaymentAmount — DECIMAL(10, 2)
  • PaymentMethod — VARCHAR(50)
  • PaymentType — VARCHAR(10)
  • IsFinalPayment — BOOLEAN