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)