Json-store-fork
Tables (12)
CopyOfdelivery
- Key — BIGINT — Primary key — NOT NULL
- Key2 — BIGINT — NOT NULL
- uuid — UUID
- address — String
- postNum — String
- phone — String
- recipient — String
- createAt — Date
- updateAt — Date
- default — Boolean
CopyOfmembers
- id — BIGINT — Primary key — NOT NULL
- uuid — UUID
- username — VARCHAR(255)
- password — VARCHAR(255)
- email — VARCHAR(255)
- phone — VARCHAR(255)
- isDeleted — boolean
- createdAt — Date
- updatedAt — Date
- deletedAt — Date
Stocks
- id — BIGINT — Primary key — NOT NULL
- uuid — UUID
- stock — BIGINT
Untitled
- id — BIGINT — Primary key — NOT NULL
- uuid — CHAR(36) — NOT NULL
- expiredAt — VARCHAR(255)
admins
- id — BIGINT — Primary key — NOT NULL
- uuid — UUID
- username — VARCHAR(255)
- password — VARCHAR(255)
- email — VARCHAR(255)
- phone — VARCHAR(255)
- isDeleted — boolean
- createdAt — Date
- updatedAt — Date
- deletedAt — Date
carts
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- amount — BIGINT — NOT NULL
- createdAt — Date
- updatedAt — Date
delivery
- Key — BIGINT — Primary key — NOT NULL
- uuid — UUID
- Key2 — BIGINT — NOT NULL
- address — String
- postNum — String
- phone — String
- recipient — String
- createAt — Date
- updateAt — Date
- id (id2) — BIGINT — Foreign key → members.id — NOT NULL
members
- id — BIGINT — Primary key — NOT NULL
- uuid — UUID
- Key — BIGINT — NOT NULL
- username — VARCHAR(255)
- password — VARCHAR(255)
- email — VARCHAR(255)
- phone — VARCHAR(255)
- isDeleted — boolean
- createdAt — Date
- updatedAt — Date
- deletedAt — Date
- Key (Key2) — BIGINT — Foreign key → delivery.Key — NOT NULL
notification
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- body — VARCHAR(255) — NOT NULL
- category — ENUM — NOT NULL
- createdAt — Date
- updatedAt — Date
order_products
- id — BIGINT — Primary key — NOT NULL
- uuid — UUID
- product_id — BIGINT — NOT NULL
- order_id — BIGINT — NOT NULL
- quantity — BIGINT
- price — BIGINT — 상품금액 * 수량
- createAt — DATE
- updateAt — DATE
orders
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — NOT NULL
- uuid — UUID
- type — ENUM
- total — BIGINT
- orderState — ENUM
- createAt — Date
- updateAt — Date
- address — VARCHAR
- phone — VARCHAR
- recipient — VARCHAR
- postNum — VARCHAR
products
- id — BIGINT — Primary key — NOT NULL
- uuid — UUID
- name — String
- price — BIGINT
- image — String
- category — Enum
- detail — String
- isActive — boolean
- createdAt — Date
- updatedAt — Date
- admin_Id (admin_id) — BIGINT — Foreign key → admins.id — NOT NULL