giticon

Tables (5)

cart (Untitled4)

  • id — BIGINT(20) — Primary key — NOT NULL
  • id (id2) — BIGINT — Foreign key → user.id — NOT NULL
  • id (id3) — BIGINT — Foreign key → gifiticon.id — NOT NULL
  • user_id — BIGINT
  • gifticon_id — BIGINT

favorite (Untitled)

  • id — BIGINT — Primary key — NOT NULL
  • id (id2) — BIGINT — Foreign key → user.id — NOT NULL
  • id (id3) — BIGINT — Foreign key → gifiticon.id — NOT NULL
  • user_id — BIGINT
  • gifticon_id — BIGINT

gifiticon (Untitled5)

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100)
  • brand — VARCHAR(50)
  • face_value — INT(11)
  • price — INT(11)
  • image_url — VARCHAR(255)
  • expire_date — DATE

purchase_history (Untitled3)

  • id — BIGINT — Primary key — NOT NULL
  • id (id2) — BIGINT — Foreign key → user.id — NOT NULL
  • user_id — BIGINT
  • total_price — INT(11)
  • purchased_at — DATETIME

user (Untitled2)

  • id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(50)