111
Tables (7)
Copy Of Untitled (CopyOfUntitled)
- Key — Primary key — NOT NULL
- Field
- Field2
- Field3
- Field4
categories
- category_id — UUID
- name — VARCHAR(100) — NOT NULL — 카테고리명
- description — TEXT — 설명
- created_at — TIMESTAMP — 생성일시
order_items
- order_item_id — UUID
- order_id — UUID — Foreign key → orders.order_id — NOT NULL — 주문
- product_id — UUID — Foreign key → products.product_id — NOT NULL — 상품
- quantity — INTEGER — NOT NULL — 수량
- price — amount_domain — NOT NULL — 단가
orders
- order_id — UUID
- user_id — UUID — Foreign key → users.user_id — NOT NULL — 사용자
- total_amount — amount_domain — NOT NULL — 총
- status — status_domain — NOT NULL — 주문
- ordered_at — TIMESTAMP — 주문일시
products
- product_id — UUID
- category_id — UUID — Foreign key → categories.category_id — NOT NULL — 카테고리
- name — VARCHAR(200) — NOT NULL — 상품명
- price — amount_domain — NOT NULL — 가격
- stock — INTEGER — NOT NULL — 재고
- status — status_domain — 상태
- created_at — TIMESTAMP — 생성일시
users
- user_id — UUID
- email — email_domain — NOT NULL — 이메일
- password — VARCHAR(255) — NOT NULL — 비밀번호
- status — status_domain — NOT NULL — 상태
- created_at — TIMESTAMP — NOT NULL — 생성일시
- updated_at — TIMESTAMP — 수정일시
ㅇㅇㅇ (Untitled)
- Key — Primary key — NOT NULL
- Field
- Field2
- Field3
- Field4