todo

Tables (6)

menu

  • id — BIGINT — Primary key
  • store_id — BIGINT — Foreign key → store.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • price — INT — NOT NULL
  • describe — VARCHAR(255)
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

order

  • id (유저식별자) — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • menu_id — BIGINT — Foreign key → menu.id — NOT NULL
  • status — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

owner

  • id — BIGINT — Primary key
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

review

  • id (Key) — BIGINT — Primary key — NOT NULL
  • order_id (유저식별자) — BIGINT — Foreign key → order.id
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • comment — VARCHAR(255) — NOT NULL — ARCHAR(255) NOT NUL
  • rate — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

store

  • id — BIGINT — Primary key
  • owner_id — BIGINT — Foreign key → owner.id
  • store_name — VARCHAR(255) — NOT NULL
  • min_price — INT — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • open_time — TIME — NOT NULL
  • close_time — TIME — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

user

  • id — BIGINT — Primary key
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL