ERD without memo

Tables (12)

p_address

  • address_id — UUID — Primary key — NOT NULL
  • user_id — LONG — Foreign key → p_user.user_id — NOT NULL
  • address — VARCHAR(255)
  • detail_address — VARCHAR(255)
  • created_at — TIMESTAMP
  • created_by — LONG
  • updated_at — TIMESTAMP
  • updated_by — LONG
  • deleted_at — TIMESTAMP
  • deleted_by — LONG

p_ai_history

  • ai_history_id — UUID — Primary key — NOT NULL
  • prompt — TEXT
  • response — TEXT
  • created_at — TIMESTAMP
  • created_by — LONG

p_category (p_store_category)

  • category_id — UUID — Primary key — 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 (image__id) — UUID — Primary key — NOT NULL
  • ref_type — VARCHAR(100)
  • ref_id — VARCHAR(100)
  • image_key — VARCHAR(255)
  • original_name — VARCHAR(255)
  • content_type — VARCHAR(50)
  • file_size — BIGINT
  • display_order — INTEGER
  • display_status — ENUM
  • created_at — TIMESTAMP
  • created_by — LONG
  • deleted_at — TIMESTAMP
  • deleted_by — LONG

p_menu

  • menu_id — UUID — Primary key — NOT NULL
  • store_id — UUID — Foreign key → p_store.store_id
  • menu_name — VARCHAR(100)
  • price — INTEGER
  • description — TEXT
  • ai_generated — BOOLEAN
  • menu_status — ENUM
  • created_at — TIMESTAMP
  • created_by — LONG
  • updated_at — TIMESTAMP
  • updated_by — LONG
  • deleted_at — TIMESTAMP
  • deleted_by — LONG

p_order

  • order_id — UUID — Primary key — NOT NULL
  • user_id — LONG — Foreign key → p_user.user_id — NOT NULL
  • store_id — UUID — Foreign key → 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 — LONG
  • updated_at — TIMESTAMP
  • updated_by — LONG
  • deleted_at — TIMESTAMP
  • deleted_by — LONG

p_order_item

  • orderitem_id — UUID — Primary key — NOT NULL
  • order_id — UUID — Foreign key → p_order.order_id
  • menu_id — UUID — Foreign key → p_menu.menu_id
  • quantity — INTEGER
  • price — INTEGER
  • created_at — TIMESTAMP
  • created_by — LONG
  • updated_at — TIMESTAMP
  • updated_by — LONG
  • deleted_at — TIMESTAMP
  • deleted_by — LONG

p_payment

  • payment_id — UUID — Primary key — NOT NULL
  • order_id — UUID — Foreign key → 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 — LONG
  • updated_at — TIMESTAMP
  • updated_by — LONG
  • deleted_at — TIMESTAMP
  • deleted_by — LONG

p_region

  • region_id — UUID — Primary key — NOT NULL
  • name — VARCHAR(100)
  • parent_region_id — UUID — Foreign key → p_region.region_id
  • status — ENUM
  • created_at — TIMESTAMP
  • created_by — LONG
  • updated_at — TIMESTAMP
  • updated_by — LONG
  • deleted_at — TIMESTAMP
  • deleted_by — LONG

p_review

  • review_id — UUID — Primary key — NOT NULL
  • store_id — UUID — Foreign key → p_store.store_id — NOT NULL
  • order_id (id2) — UUID — Foreign key → p_order.order_id — NOT NULL
  • user_id — LONG — Foreign key → p_user.user_id — NOT NULL
  • rating — INTEGER — NOT NULL
  • content — TEXT
  • created_at — TIMESTAMP
  • created_by — LONG
  • updated_at — TIMESTAMP
  • updated_by — LONG
  • deleted_at — TIMESTAMP
  • deleted_by — LONG

p_store

  • store_id — UUID — Primary key — NOT NULL
  • user_id — LONG — Foreign key → p_user.user_id — NOT NULL
  • category_id — UUID — Foreign key → p_category.category_id
  • region_id — UUID — Foreign key → 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

p_user

  • user_id — LONG — Primary key — NOT NULL
  • username (Field) — VARCHAR(100)
  • nickname — VARCHAR(100)
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • role — ENUM(`CUSTOMER`, `OWNER`, `MANAGER`, `MASTER`)
  • phone — VARCHAR(11)
  • created_at — TIMESTAMP
  • created_by — LONG
  • updated_at — TIMESTAMP
  • updated_by — LONG
  • deleted_at — TIMESTAMP
  • deleted_by — LONG
  • is_deleted — BOOLEAN