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)