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