최종

테이블 (12)

p_address

  • id — UUID — 기본 키 — NOT NULL
  • address — VARCHAR(255)
  • detail_address — VARCHAR(255)
  • created_at — TIMESTAMP
  • created_by — VARCHAR(100)
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)
  • status — ENUM
  • user_id — LONG — 외래 키 → p_user.user_id

p_ai_history (AI 히스토리 프롬프트)

  • ai_history_id — UUID — 기본 키 — NOT NULL
  • menu_id — UUID — 외래 키 → p_menu.menu_id
  • prompt — TEXT
  • response — TEXT
  • created_at — TIMESTAMP
  • created_by — VARCHAR(100)
  • user_id (user_id2) — LONG — 외래 키 → p_menu.user_id

p_category

  • category_id (id) — UUID — 기본 키 — NOT NULL
  • name — VARCHAR(100)
  • status — ENUM
  • created_at — TIMESTAMP
  • created_by — LONG
  • updated_at — TIMESTAMP
  • updated_by — LONG
  • deleted_at — TIMESTAMP
  • deleted_by — LONG

p_image_file (이미지 파일)

  • image_id — UUID — 기본 키 — NOT NULL
  • ref_id — VARCHAR(100)
  • ref_type — VARCHAR(100)
  • image_url — VARCHAR(255)
  • original_name — VARCHAR(255)
  • saved_name — VARCHAR(255)
  • content_type — VARCHAR(50)
  • file_size — BIGINT
  • display_order — INTEGER
  • display_status — CHAR(1)
  • created_at — TIMESTAMP
  • created_by — VARCHAR(50)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(50)

p_menu (메뉴)

  • menu_id — UUID — 기본 키 — NOT NULL
  • store_id — UUID — 외래 키 → p_store.store_id
  • menu_name — VARCHAR(100)
  • price — INTEGER
  • description — TEXT
  • ai_generated — BOOLEAN
  • menu_status — CHAR(1)
  • created_at — TIMESTAMP
  • created_by — VARCHAR(50)
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(50)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(50)
  • user_id (user_id2) — LONG — 외래 키 → p_store.user_id

p_order

  • order_id — UUID — 기본 키 — NOT NULL
  • store_id — UUID — 외래 키 → p_store.store_id
  • address — VARCHAR(255)
  • detail_address — VARCHAR(255)
  • total_price — INTEGER
  • status — ENUM('REQUESTED, ACCEPTED, COOKING, DELIVERING, DELIVERED, COMPLETED, CANCELED')
  • created_at — TIMESTAMP
  • created_by — VARCHAR(100)
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)
  • user_id (user_id2) — LONG — 외래 키 → p_user.user_id

p_order_item

  • orderitem_id — UUID — 기본 키 — NOT NULL
  • order_id — UUID — 외래 키 → p_order.order_id
  • menu_id — UUID — 외래 키 → p_menu.menu_id
  • quantity — INTEGER
  • price — INTEGER
  • created_at — TIMESTAMP
  • created_by — VARCHAR(100)
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)
  • user_id (user_id2) — LONG — 외래 키 → p_order.user_id

p_payment

  • payment_id — UUID — 기본 키 — NOT NULL
  • order_id — UUID — 외래 키 → p_order.order_id
  • payment_method — VARCHAR(30)
  • card_company — VARCHAR(50)
  • amount — INTEGER
  • status — ENUM('READY, SUCCESS, FAIL, CANCELED')
  • approved_at — TIMESTAMP
  • created_at — TIMESTAMP
  • created_by — VARCHAR(100)
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)
  • user_id (user_id2) — LONG — 외래 키 → p_order.user_id

p_region

  • region_id (id) — UUID — 기본 키 — NOT NULL
  • parent_region_id — UUID — 외래 키 → p_region.region_id
  • name — VARCHAR(100)
  • status — ENUM
  • created_at — TIMESTAMP
  • created_by — LONG
  • updated_at — TIMESTAMP
  • updated_by — LONG
  • deleted_at — TIMESTAMP
  • deleted_by — LONG

p_review

  • review_id (id) — UUID — 기본 키 — NOT NULL
  • store_id — UUID — 외래 키 → p_store.store_id — NOT NULL
  • order_id — UUID — 외래 키 → p_order.order_id — NOT NULL
  • rating — INTEGER — NOT NULL
  • content — TEXT
  • created_at — TIMESTAMP
  • created_by — VARCHAR(100)
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)
  • user_id — LONG — 외래 키 → p_user.user_id

p_store

  • store_id (id) — UUID — 기본 키 — NOT NULL
  • category_id — UUID — 외래 키 → p_category.category_id
  • region_id — UUID — 외래 키 → p_region.region_id
  • name — VARCHAR(100)
  • address — VARCHAR(255)
  • phone — VARCHAR(30)
  • open_time — TIME
  • close_time — TIME
  • status — ENUM
  • created_at — TIMESTAMP
  • created_by — LONG
  • updated_at — TIMESTAMP
  • updated_by — LONG
  • deleted_at — TIMESTAMP
  • deleted_by — LONG
  • user_id (user_id2) — LONG — 외래 키 → p_user.user_id

p_user

  • user_id — LONG — 기본 키
  • nickname — VARCHAR(100)
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • role — ENUM(`CUSTOMER`, `OWNER`, `MANAGER`, `MASTER`)
  • phone — VARCHAR(30)
  • created_at — TIMESTAMP
  • created_by — VARCHAR(100)
  • updated_at — TIMESTAMP
  • updated_by — VARCHAR(100)
  • deleted_at — TIMESTAMP
  • deleted_by — VARCHAR(100)
  • status — ENUM
  • username — VARCHAR(100) — NOT NULL