database_test
Tables (6)
Customer (Untitled)
- customerId (Key) — int — Primary key — NOT NULL
- name (Field) — varchar(255)
- email (Field2) — varchar(255)
- phoneNumber (Field3) — varchar(20)
Orders (Untitled3)
- orderId (Key) — int — Primary key — NOT NULL
- customerId (Key2) — int — Foreign key → Customer.customerId — NOT NULL
- orderDate (Field) — datetime
- deliveryStatus (Field2) — varchar(50)
- paymentStatus (Field3) — varchar(50)
deliveryAddress (Untitled2)
- addressId (Key) — int — Primary key — NOT NULL
- customerId (Key2) — int — Foreign key → Customer.customerId — NOT NULL
- customerId (Field) — int
- address (Field2) — varchar(255)
payment (Untitled4)
- paymentId (Key) — int — Primary key — NOT NULL
- orderId (Key2) — int — Foreign key → Orders.orderId — NOT NULL
- amount (Field) — decimal(10,2)
- paymentMethod (Field2) — varchar(50)
- paymentStatus (Field3) — varchar(50)
product (Untitled5)
- productId (Key) — int — Primary key — NOT NULL
- productCode (Field) — varchar(100)
- category (Field2) — varchar(50)
- stockQuantity (Field3) — int
- price (Field4) — decimal(10,2)
review (Untitled6)
- reviewId (Key) — int — Primary key — NOT NULL
- customerId (Key2) — int — Foreign key → Customer.customerId — NOT NULL
- productId (Key3) — int — Foreign key → product.productId — NOT NULL
- content (Field) — text
- raiting (Field2) — int
- reviewDate (Field3) — date