df
Tables (6)
following
- id — bigint — Primary key — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- follower_id — bigint — NOT NULL
- id (following_id) — bigint — Foreign key → member.id — NOT NULL
inventory_product
- id — bigint — Primary key — NOT NULL
- selected — TINYINT(1)
- id (product_id) — bigint — Foreign key → product.id — NOT NULL
- id (member_id) — bigint — Foreign key → member.id — NOT NULL
member
- id — bigint — Primary key — NOT NULL
- career_level — varchar(255)
- follower_count — int — NOT NULL
- github_id — varchar(255) — NOT NULL
- image_url — varchar(15000) — NOT NULL
- job_type — varchar(255)
- name — varchar(255)
- registered — TINYINT(1) — NOT NULL
- role — varchar(255) — NOT NULL
product
- id — bigint — Primary key — NOT NULL
- category — varchar(255)
- image_url — varchar(15000) — NOT NULL
- name — varchar(255) — NOT NULL
- avg_rating — double — NOT NULL
- review_count — int — NOT NULL
- total_rating — int — NOT NULL
refresh_token
- token_value — varchar(50)
- expired_at — TIMESTAMP — NOT NULL
- member_id — bigint — NOT NULL
review
- id — bigint — Primary key — NOT NULL
- content — varchar(1000) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- rating — int — NOT NULL
- id (member_id) — bigint — Foreign key → member.id — NOT NULL
- id (product_id) — bigint — Foreign key → product.id — NOT NULL