Giftic

Tables (7)

Alarm (Untitled7)

  • Alarm_id (Key) — Long — Primary key — NOT NULL

Delivery_image (Untitled5)

  • Delivery (Key) — Long — Primary key — NOT NULL
  • status (Field) — enum
  • Field2
  • order_id (Field3) — Long — Foreign key → Order.order_id — NOT NULL
  • member_id (Key2) — Long — Foreign key → Order.member_id — NOT NULL

Donate (Untitled4)

  • donate_id (Key) — Long — Primary key — NOT NULL
  • title (Field) — String
  • content (Field2) — String
  • category (Field4) — enum
  • Imgae (Field5) — String
  • Field3

Member (Untitled)

  • member_id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • nickName (Field2) — String
  • oauth_id (Field3) — String

Order (Untitled2)

  • order_id (Field) — Long — Primary key — NOT NULL
  • member_id (Key) — Long — Foreign key → Member.member_id — NOT NULL
  • delivery_id (Field2) — Long
  • orderdate (Field3) — int
  • status (Field4) — enum
  • Field6

Order_Donate (Untitled3)

  • order_donate_id (Key) — Long — Primary key — NOT NULL
  • stockMember (Field) — int
  • Field2

win_orders (Untitled6)

  • win_orders_id (Key) — Long — Primary key — NOT NULL