tour-app

Tables (9)

BASE_ENTITY (Untitled2)

  • Field

MEMBER (member)

  • 아이디 (id) — Primary key — NOT NULL
  • 이름 (name)
  • 비밀번호 (password)

MENU (menu)

  • Key (id) — Primary key — NOT NULL
  • 중분류 (name)
  • Field (link)
  • Field (parent_id)
  • Field (order)
  • Field (status)
  • Field (created_at)
  • Field (updated_at)

Untitled (card)

  • Key (id) — Primary key — NOT NULL
  • Key (menu_id) — Foreign key → MENU.Key — NOT NULL
  • Field (title)
  • Field (content1)
  • Field (itinerary_count)
  • Field (cities)
  • Field (price)
  • Field (link)
  • Field (created_at)
  • Field2 (updated_at)

Untitled (file)

  • Key (id) — Primary key — NOT NULL
  • Field (name)
  • Field (path)
  • Field (size)
  • Field (type)
  • Field (created_at)
  • Field (updated_at)
  • Key (id2) — Foreign key → Untitled.Key — NOT NULL

Untitled (itinerary)

  • Key (id) — Primary key — NOT NULL
  • Field (title)
  • Field
  • Key (id2) — Foreign key → Untitled.Key — NOT NULL

Untitled (quote_board)

  • Key (id) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

Untitled (mainCard)

  • Key (id) — Primary key — NOT NULL
  • Field (title)
  • Field (description)
  • Field (price)
  • Field (link)
  • Field (file_id)

Untitled (main_card_file)

  • Key (id) — Primary key — NOT NULL
  • Field (name)
  • Field2 (path)
  • Field3 (size)
  • Field4 (type)
  • Field (created_at)
  • Field (updated_at)
  • Key (id2) — Foreign key → Untitled.Key — NOT NULL