AthenaDoctrine
Tables (9)
address
- id — int(10) — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- label — varchar(15) — NOT NULL
- recipient — varchar(17) — NOT NULL
- recipient_phone — char(11) — NOT NULL
- postal_code — char(5) — NOT NULL
- address — varchar(255) — NOT NULL
- address_detail — varchar(255) — NOT NULL
- is_default — tinyint(4) — NOT NULL
- used_at — datetime(6)
- user_id — int(10) — Foreign key → user.id — NOT NULL
cart
- id — int(10) — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- user_id — int(10) — Foreign key → user.id — NOT NULL
cart_item
- id — int(10) — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- quantity — tinyint(3) — NOT NULL
common
- id — int(10) — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
product
- id — int(10) — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- code — varchar(50)
- name — varchar(50) — NOT NULL
- description — text — NOT NULL
question
- id — int(10) — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- title — varchar(100) — NOT NULL
- content — text — NOT NULL
- is_private — tinyint(4) — NOT NULL
- user_id — int(10) — Foreign key → user.id — NOT NULL
review
- id — int(10) — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- content — varchar(1000) — NOT NULL
- image_url — varchar(2083)
- rating — tinyint(3) — NOT NULL
- user_id — int(10) — Foreign key → user.id — NOT NULL
user
- id — int(10) — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- email — varchar(255) — NOT NULL
- username — varchar(17) — NOT NULL
- password — varchar(255)
- name — varchar(17) — NOT NULL
- phone — varchar(11)
- point — int(11) — NOT NULL
- role — char(5) — NOT NULL
- provider — varchar(20) — NOT NULL
- sns_id — varchar(255)
- refresh_token — varchar(255)
wishlist
- id — int(10) — Primary key — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- user_id — int(10) — Foreign key → user.id — NOT NULL