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)