MainPage_ERD

Tables (5)

image (Untitled3)

  • image_id (Key) — INT — Primary key — NOT NULL
  • path (Field) — VARCHAR(255)
  • perform_id (Key2) — INT — Foreign key → performances.perform_id — NOT NULL

order_details (Untitled4)

  • order_detail_id (Key) — INT — Primary key — NOT NULL
  • contact (Field2)
  • order_id (Key2) — INT — Foreign key → orders.order_id — NOT NULL

orders (Untitled2)

  • order_id (Key) — INT — Primary key — NOT NULL
  • quantity (Field3) — INT
  • order_date (Field4) — DATE
  • total_price (Field5) — INT
  • user_id (Key2) — INT — Foreign key → users.user_id — NOT NULL
  • perform_id (Key3) — INT — Foreign key → performances.perform_id — NOT NULL

performances (Untitled)

  • perform_id (Key) — INT — Primary key — NOT NULL
  • title (Field) — VARCHAR(100)
  • date (Field2) — DATE
  • price (Field3) — INT
  • main_image_id (Field4) — INT
  • description (Field5) — TEXT

users (자료형)

  • user_id (Key) — VARCHAR(100) — Primary key — NOT NULL
  • name (Field) — VARCHAR(30)
  • password (Field2) — VARCHAR(255)
  • email (Field3) — VARCHAR(100)
  • address (Field4) — VARCHAR(100