ourmenu2

Tables (7)

Menu

  • menu_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → User.user_id — NOT NULL
  • store_id — BIGINT — Foreign key → Place.place_id — NOT NULL
  • menuFolder_id — BIGINT — Foreign key → MenuFolder.menuFolder_id — NOT NULL
  • title — VARCHAR — NOT NULL
  • price — BIGINT — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • status — VARCHAR — NOT NULL
  • memo — VARCHAR
  • icon — VARCHAR
  • Field — VARCHAR(255)

MenuFolder

  • menuFolder_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → User.user_id — NOT NULL
  • title — VARCHAR — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • status — VARCHAR — NOT NULL
  • img_url — VARCHAR
  • icon_type (icon_typr) — VARCHAR — NOT NULL
  • priority — BIGINT — NOT NULL

MenuImage

  • menu_image_id — BIGINT — Primary key — NOT NULL
  • menu_id — BIGINT — Foreign key → Menu.menu_id — NOT NULL
  • img_url — VARCHAR — NOT NULL

Menu_Tag

  • menu_tag_id — BIGINT — Primary key — NOT NULL
  • menu_id — BIGINT — Foreign key → Menu.menu_id — NOT NULL
  • tag_id — BIGINT — Foreign key → Tag.tag_id — NOT NULL

Place

  • place_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → User.user_id — NOT NULL
  • latitude — decimal(20, 17) — NOT NULL
  • longitude — decimal(20, 17) — NOT NULL
  • title — VARCHAR — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • status — VARCHAR — NOT NULL
  • address — VARCHAR — NOT NULL
  • memo — VARCHAR

Tag

  • tag_id — BIGINT — Primary key — NOT NULL
  • tag_name — VARCHAR — NOT NULL
  • isCustom — VARCHAR — NOT NULL

User

  • user_id — BIGINT — Primary key — NOT NULL
  • nickname — VARCHAR — NOT NULL
  • password — VARCHAR — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp — NOT NULL
  • email — VARCHAR — NOT NULL
  • status — VARCHAR — NOT NULL
  • img_url — VARCHAR