ch.1

Tables (11)

Untitled (P_USER)

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Field (USERNAME) — VARCHAR(10)
  • Field (EMAIL) — VARCHAR(255)
  • Field (PASSWORD) — VARCHAR(15)
  • Field2 (ROLE) — ENUM
  • Field (IS_AVAILABLE) — BOOLEAN
  • Field (CREATED_AT) — TIMESTAMP
  • Field (CREATED_BY) — VARCHAR(100)
  • Field (UPDATED_AT) — TIMESTAMP
  • Field (UPDATED_BY) — VARCHAR(100)
  • Field (DELETED_AT) — TIMESTAMP
  • Field (DELETED_BY) — VARCHAR(100)

Untitled (P_STORE)

  • Key (ID) — UUID — Primary key — NOT NULL
  • Key (USER_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (LEGAL_DONG_CODE_ID) — VARCHAR(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (NAME) — VARCHAR(50)
  • Field (ADDRESS) — VARCHAR(150)
  • Field (PHONE_NUMBER) — VARCHAR(30)
  • Field (IS_OPEN) — BOOLEAN
  • Field (IS_PUBLIC) — BOOLEAN
  • Field (CREATED_AT) — TIMESTAMP
  • Field (CREATED_BY) — VARCHAR(100)
  • Field (UPDATED_AT) — TIMESTAMP
  • Field (UPDATED_BY) — VARCHAR(100)
  • Field (DELETED_AT) — TIMESTAMP
  • Field (DELETED_BY) — VARCHAR(100)

Untitled (P_LEGAL_DONG_CODE)

  • Key (ID) — VARCHAR(10) — Primary key — NOT NULL
  • Field (SIDO) — VARCHAR(40)
  • Field (SIGUNGU) — VARCHAR(40)
  • Field (DONG) — VARCHAR(40)
  • Field (IS_AVAILABLE) — BOOLEAN

Untitled (P_PRODUCT)

  • Key (ID) — UUID — Primary key — NOT NULL
  • Key (STORE_ID) — UUID — Foreign key → Untitled.Key — NOT NULL
  • Field (NAME) — VARCHAR(100)
  • Field (DESCRIPTION) — TEXT
  • Field (PRICE) — DECIMAL(10,2)
  • Field (IMAGE_URL) — VARCHAR(255)
  • Field (IS_AVAILABLE) — BOOLEAN
  • Field (CREATED_AT) — TIMESTAMP
  • Field (CREATED_BY) — VARCHAR(100)
  • Field (UPDATED_AT) — TIMESTAMP
  • Field (UPDATED_BY) — VARCHAR(100)
  • Field (DELETED_AT) — TIMESTAMP
  • Field (DELETED_BY) — VARCHAR(100)

Untitled (P_ORDER)

  • Key (ID) — UUID — Primary key — NOT NULL
  • Key (STORE_ID) — UUID — Foreign key → Untitled.Key — NOT NULL
  • Key (CUSTOMER_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (ORDER_TYPE) — ENUM
  • Field (TOTAL_PRICE) — DECIMAL(10, 2)
  • Field (STATUS) — ENUM
  • Field (CREATED_AT) — TIMESTAMP
  • Field (ADDRESS) — VARCHAR(150)
  • Field (CANCEL_REASON) — VARCHAR(100)
  • Field (REQUEST) — VARCHAR(150)
  • Field (CREATED_BY) — VARCHAR(100)
  • Field (UPDATED_AT) — TIMESTAMP
  • Field (UPDATED_BY) — VARCHAR(100)
  • Field (DELETED_AT) — TIMESTAMP
  • Field (DELETED_BY) — VARCHAR(100)

Untitled (P_ORDER_ITEM)

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Key (ORDER_ID) — UUID — Foreign key → Untitled.Key — NOT NULL
  • Key (PRODUCT_ID) — UUID — Foreign key → Untitled.Key — NOT NULL
  • Field (AMOUNT) — BIGINT
  • Field (PRICE) — DECIMAL(10, 2)

Untitled (P_PAYMENTS)

  • Key (ID) — UUID — Primary key — NOT NULL
  • Key (ORDER_ID) — UUID — Foreign key → Untitled.Key — NOT NULL
  • Key (USER_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (TOTAL_PRICE) — DECIMAL(10, 2)
  • Field (STATUS) — ENUM
  • Field (CANCEL_REASON) — VARCHAR(100)
  • Field (PAYMENT_METHOD) — ENUM
  • Field (TRANSACTION_ID) — VARCHAR(100)
  • Field (CREATED_AT) — TIMESTAMP
  • Field (CREATED_BY) — VARCHAR(100)
  • Field (UPDATED_AT) — TIMESTAMP
  • Field (UPDATED_BY) — VARCHAR(100)
  • Field (DELETED_AT) — TIMESTAMP
  • Field (DELETED_BY) — VARCHAR(100)

Untitled (P_REVIEW)

  • Key (ID) — UUID — Primary key — NOT NULL
  • Key (ORDER_ID) — UUID — Foreign key → Untitled.Key — NOT NULL
  • Key (STORE_ID) — UUID — Foreign key → Untitled.Key — NOT NULL
  • Key (CUSTOMER_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (CONTENT) — TEXT
  • Field (IMAGE_URL) — VARCHAR(255)
  • Field (RATING) — DECIMAL(10, 2)
  • Field (IS_PUBLIC) — BOOLEAN
  • Field (CREATED_AT) — TIMESTAMP
  • Field (CREATED_BY) — VARCHAR(100)
  • Field (UPDATED_AT) — TIMESTAMP
  • Field (UPDATED_BY) — VARCHAR
  • Field (DELETED_AT) — TIMESTAMP
  • Field (DELETED_BY) — VARCHAR(100)

Untitled (P_AI)

  • Key (ID) — UUID — Primary key — NOT NULL
  • Key (STORE_ID) — UUID — Foreign key → Untitled.Key — NOT NULL
  • Key (PRODUCT_ID) — UUID — Foreign key → Untitled.Key — NOT NULL
  • Field (REQUEST_TEXT) — TEXT
  • Field (RESPONSE_TEXT) — TEXT
  • Field (CREATED_AT) — TIMESTAMP
  • Field (CREATED_BY) — VARCHAR(100)
  • Field (UPDATED_AT) — TIMESTAMP
  • Field (UPDATED_BY) — VARCHAR(100)
  • Field (DELETED_AT) — TIMESTAMP
  • Field (DELETED_BY) — VARCHAR(100)

Untitled (P_DELIVERY)

  • Key (ID) — UUID — Primary key — NOT NULL
  • Key (ORDER_ID) — UUID — Foreign key → Untitled.Key — NOT NULL
  • Field (STATUS) — ENUM
  • Field (CREATED_AT) — TIMESTAMP
  • Field (CREATED_BY) — VARCHAR(100)
  • Field (UPDATED_AT) — TIMESTAMP
  • Field (UPDATED_BY) — VARCHAR(100)
  • Field (DELETED_AT) — TIMESTAMP
  • Field (DELETED_BY) — VARCHAR(100)

Untitled (P_CATEGORY)

  • Key (ID) — UUID — Primary key — NOT NULL
  • Key (STORE_ID) — UUID — Foreign key → Untitled.Key — NOT NULL
  • Field (NAME) — VARCHAR(10)
  • Field (IS_AVAILABLE) — BOOLEAN
  • Field (CREATED_AT) — TIMESTAMP
  • Field (CREATED_BY) — VARCHAR(100)
  • Field (UPDATED_AT) — TIMESTAMP
  • Field (UPDATED_BY) — VARCHAR(100)
  • Field (DELETED_AT) — TIMESTAMP
  • Field (DELETED_BY) — VARCHAR(100)