SURA COPY
테이블 (12)
AI기록 (P_AI_LOG)
- ID — BIGINT — 기본 키 — NOT NULL
- ORDER_ID — BIGINT — NOT NULL
- REQUEST_PROMPT — TEXT
- RESPONSE_CONTENT — TEXT
- MODEL — VARCHAR(50)
- TOKEN_USED — INT
- STATUS — VARCHAR(10)
- CREATED_AT — TIMESTAMP
결제 (P_PAYMENT)
- ID — BIGINT — 기본 키 — NOT NULL
- ORDER_ID — BIGINT — NOT NULL
- PRICE — INT
- STATUS — VARCHAR(30)
- METHOD — VARCHAR(30)
- APPROVED_AT — TIMESTAMP
- CREATED_AT — TIMESTAMP
- UPDATED_AT — TIMESTAMP
답글 (P_REPLY)
- ID — BIGINT — 기본 키 — NOT NULL
- REVIEW_ID — BIGINT — 외래 키 → 리뷰.ID — NOT NULL
- CONTENT — TEXT
- CREATED_AT — TIMESTAMP
- UPDATED_AT — TIMESTAMP
- DELETED_AT — TIMESTAMP
리뷰 (P_REVIEW)
- ID — BIGINT — 기본 키 — NOT NULL
- ORDER_ID — BIGINT — NOT NULL
- STORE_ID — BIGINT — NOT NULL
- REVIEWER_ID — BIGINT — NOT NULL
- CONTENT — TEXT
- RATING — INTEGER
- CREATED_AT — TIMESTAMP
사용자 (P_USER)
- ID — BIGINT — 기본 키 — NOT NULL
- ROLE — VARCHAR(10)
- NICKNAME — VARCHAR(100)
- EMAIL — VARCHAR(255)
- PASSWORD — VARCHAR(255)
- ADDRESS — VARCHAR(255)
- CREATED_AT — TIMESTAMP
- UPDATED_AT — TIMESTAMP
- DELETED_AT — TIMESTAMP
음식 (P_MENU)
- ID — BIGINT — 기본 키 — NOT NULL
- NAME — VARCHAR(100)
- MENU_INFO — VARCHAR(255)
- PRICE — INTEGER
- IS_DELETED — BOOLEAN
- CREATED_AT — TIMESTAMP
- UPDATED_AT — TIMESTAMP
- DELETED_AT — TIMESTAMP
- STORE_ID — BIGINT — 외래 키 → 음식점.ID — NOT NULL
음식점 (P_STORE)
- ID — BIGINT — 기본 키 — NOT NULL
- STORE_NAME — VARCHAR(100)
- RATING — NUMERIC
- USER_ID — BIGINT — NOT NULL
- CREATED_AT — TIMESTAMP
- UPDATED_AT — TIMESTAMP
- DELETED_AT — TIMESTAMP
- REGION_ID — BIGINT — 외래 키 → 지역.ID — NOT NULL
음식점-카테고리매핑 (P_SC_MAP)
- ID — BIGINT — 기본 키 — NOT NULL
- STORE_ID — BIGINT — 외래 키 → 음식점.ID — NOT NULL
- CATEGORY_ID — BIGINT — 외래 키 → 카테고리.ID — NOT NULL
주문 (P_ORDER)
- ID — BIGINT — 기본 키 — NOT NULL
- USER_ID — BIGINT — NOT NULL
- STORE_ID — BIGINT — NOT NULL
- TOTAL_AMOUNT — BIGINT
- STATUS — VARCHAR(10)
- CREATED_AT — TIMESTAMP
- UPDATED_AT — TIMESTAMP
- CANCELED_AT — TIMESTAMP
주문된 음식 (P_ORDER_ITEM)
- ID — BIGINT — 기본 키 — NOT NULL
- MENU_ID — BIGINT — NOT NULL
- QUANTITY — INTEGER
- PRICE — INTEGER
- ORDER_ID — BIGINT — 외래 키 → 주문.ID — NOT NULL
지역 (P_REGION)
- ID — BIGINT — 기본 키 — NOT NULL
- REG_NAME — VARCHAR(100)
- LEVEL — SMALLINT
- IS_ACTIVE — BOOLEAN
- PARENT_ID — BIGINT
- CREATED_AT — TIMESTAMP
- UPDATED_AT — TIMESTAMP
- DELETED_AT — TIMESTAMP
카테고리 (P_CATEGORY)
- ID — BIGINT — 기본 키 — NOT NULL
- CATEGORY_NAME — VARCHAR(10)