Baemin

Tables (7)

Address

  • id — bigint — Primary key — NOT NULL
  • road_address — varchar(40)
  • detail_address — varchar(40)
  • is_default — boolean
  • user_id — bigint — Foreign key → User.id — NOT NULL

Menu

  • id — bigint — Primary key — NOT NULL
  • menu_name — varchar(40)
  • description — text
  • price — int
  • is_available — boolean
  • id (id2) — bigint — Foreign key → Restaurant.id — NOT NULL

Order

  • id — bigint — Primary key — NOT NULL
  • status — varchar(20)
  • total_price — int
  • payment_method — varchar(20)
  • address_id — bigint — Foreign key → Address.id — NOT NULL
  • user_id — bigint — Foreign key → User.id — NOT NULL
  • restaurant_id — bigint — Foreign key → Restaurant.id — NOT NULL
  • request_note — text
  • ordered_at — timestamp

OrderItem

  • id — bigint — Primary key — NOT NULL
  • menu_id — bigint — Foreign key → Menu.id — NOT NULL
  • order_id — bigint — Foreign key → Order.id — NOT NULL
  • quantity — int
  • unit_price — int

Restaurant

  • id — bigint — Primary key — NOT NULL
  • restaurant_name — varchar(20)
  • category — varchar
  • address — varchar(40)
  • min_order_amount — float
  • delivery_fee — float
  • rate — float
  • is_open — boolean

Review

  • id — bigint — Primary key — NOT NULL
  • order_id — bigint — Foreign key → Order.id — NOT NULL
  • user_id — bigint — Foreign key → User.id — NOT NULL
  • restaurant_id — bigint — Foreign key → Restaurant.id — NOT NULL
  • rate — int
  • content — text
  • created_at — timestamp

User

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint
  • user_name — varchar(20)
  • password — bigint
  • email — varchar(20)
  • phone_number — varchar(20)
  • created_at — timestamp
  • updated_at — timestamp