monthly life
Tables (25)
announcement
- idx — BIGINT(20) — Primary key — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- content — VARCHAR(45)
- title — VARCHAR(45)
billing_key
- idx — BIGINT(20) — Primary key — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- user_id — VARCHAR(20) — Foreign key → user.id
- billing_key — VARCHAR(255)
- card_company — VARCHAR(255)
- card_number — VARCHAR(255)
- INDEX — `FKlflmrt74ojjvhxuyb9r5htrv`
cart
- idx — BIGINT(20) — Primary key — NOT NULL
- created_at — DATETIME(6)
- sale_price_idx — BIGINT(20) — Foreign key → sale_price.idx
- updated_at — DATETIME(6)
- user_idx — VARCHAR(20) — Foreign key → user.id
- INDEX — `FKex37d7jaydn4igy2x8m2194d0`
- INDEX — `FK98tugifmcl6h3v8etu1y8stu7`
category
- idx — BIGINT(20) — Primary key — NOT NULL
- created_at — DATETIME(6)
- parent_idx — BIGINT(20) — Foreign key → category.idx
- updated_at — DATETIME(6)
- icon_url — VARCHAR(255)
- name — VARCHAR(255)
- INDEX — `FK21o2kr8v9hjy189vvfeqwxkxf`
chat
- idx — BIGINT(20) — Primary key — NOT NULL
condition
- idx — BIGINT(20) — Primary key — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- name — VARCHAR(255)
item
- idx — BIGINT(20) — Primary key — NOT NULL
- count — INT(11) — NOT NULL
- condition_idx — BIGINT(20) — Foreign key → condition.idx
- created_at — DATETIME(6)
- itemlocation_idx — BIGINT(20) — Foreign key → item_location.idx
- updated_at — DATETIME(6)
- product_idx — VARCHAR(255) — Foreign key → product.code
- INDEX — `FKaejv3x540t2b75wu6bis9jtw5`
- INDEX — `FK3oh9ky5pl2uspj9j5kdra3ba0`
- INDEX — `FKrtxd5e65rqmip7vcmf2ffa4dl`
item_location
- idx — BIGINT(20) — Primary key — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- name — VARCHAR(255)
payment
- idx — BIGINT(20) — Primary key — NOT NULL
- is_paid — BIT(1) — NOT NULL
- created_at — DATETIME(6)
- price — BIGINT(20)
- subscribe_idx — BIGINT(20) — Foreign key → subscribe.idx
- updated_at — DATETIME(6)
- payment_id — VARCHAR(255)
- INDEX — `FKgmd9rmi4bm9xq24tafnbnmysn`
product
- code — VARCHAR(255) — Primary key — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- description — VARCHAR(255)
- manufacturer — VARCHAR(255)
- name — VARCHAR(255)
product_image
- idx — BIGINT(20) — Primary key — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- product_idx — VARCHAR(255) — Foreign key → product.code
- product_img_url — VARCHAR(255)
- INDEX — `FKhqt1b9qmen7hstlpkeq7l4vbu`
product_price
- idx — BIGINT(20) — Primary key — NOT NULL
- condition_idx — BIGINT(20) — Foreign key → condition.idx
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- description — VARCHAR(255)
- name — VARCHAR(255)
- product_code — VARCHAR(255)
- product_idx — VARCHAR(255) — Foreign key → product.code
- INDEX — `FKrv2cf2g3ble4hqqj7xcov2yhd`
- INDEX — `FKm16rtexu70mkx8en4yar9us7n`
rental_delivery
- idx — BIGINT(20) — Primary key — NOT NULL
- created_at — DATETIME(6)
- subscribe_detail_idx — BIGINT(20) — Foreign key → subscribe_detail.idx
- updated_at — DATETIME(6)
- address1 — VARCHAR(255)
- address2 — VARCHAR(255)
- courier_company — VARCHAR(255)
- delivered_at — VARCHAR(255)
- delivery_memo — VARCHAR(255)
- postal_code — VARCHAR(255)
- recipient_name — VARCHAR(255)
- recipient_phone — VARCHAR(255)
- shipped_at — VARCHAR(255)
- status — VARCHAR(255)
- tracking_number — VARCHAR(255)
- INDEX — `FK8ps89phqrnlubf43s25cbswqw`
repair_image
- idx — BIGINT(20) — Primary key — NOT NULL
- repair_request_idx — BIGINT(20) — Foreign key → repair_request.idx
- url — VARCHAR(255)
- INDEX — `FKjkn8de0s3wef7an0mjxa5pqwx`
repair_request
- idx — BIGINT(20) — Primary key — NOT NULL
- created_at — DATETIME(6)
- subscribe_detail_idx — BIGINT(20) — Foreign key → subscribe_detail.idx
- updated_at — DATETIME(6)
- description — VARCHAR(255)
- status — VARCHAR(255)
- INDEX — `FKhk2bpiuic1k74hs398vq8a1j1`
return_delivery
- idx — INT(11) — Primary key — NOT NULL
- created_at — DATETIME(6)
- pickup_date — DATETIME(6)
- subscribe_detail_idx — BIGINT(20) — Foreign key → subscribe_detail.idx
- updated_at — DATETIME(6)
- address1 — VARCHAR(255)
- address2 — VARCHAR(255)
- description — VARCHAR(255)
- subscribe_name — VARCHAR(255)
- subscribe_phone — VARCHAR(255)
- status — ENUM('CANCELED', 'COMPLETED', 'REQUESTED') — NOT NULL
- INDEX — `FKm6cixdid5qo6n73grk43n9s0o`
sale
- idx — BIGINT(20) — Primary key — NOT NULL
- category_idx — BIGINT(20)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- description — VARCHAR(255)
- name — VARCHAR(255)
sale_has_product
- idx — BIGINT(20) — Primary key — NOT NULL
- condition_idx — BIGINT(20) — Foreign key → condition.idx
- created_at — DATETIME(6)
- sale_idx — BIGINT(20) — Foreign key → sale.idx
- updated_at — DATETIME(6)
- product_code — VARCHAR(255) — Foreign key → product.code
- INDEX — `FKobj0o82yshmcjqgl6lshp1av6`
- INDEX — `FKpt4xl3dqkrfohe589t6or6aaq`
- INDEX — `FKi8hg8khddq4ce6n426nx8ibpk`
sale_has_user_tag
- idx — BIGINT(20) — Primary key — NOT NULL
- created_at — DATETIME(6)
- sale_idx — BIGINT(20) — Foreign key → sale.idx
- updated_at — DATETIME(6)
- user_tag_idx — BIGINT(20) — Foreign key → user_tag.idx
- INDEX — `FKp94ndkj227qmn0p2xi0uv8kd2`
- INDEX — `FK6m54tl5rq4yuteapowlv3qas9`
sale_price
- idx — BIGINT(20) — Primary key — NOT NULL
- period — INT(11) — NOT NULL
- price — INT(11) — NOT NULL
- created_at — DATETIME(6)
- sale_idx — BIGINT(20) — Foreign key → sale.idx
- updated_at — DATETIME(6)
- INDEX — `FKrl1x23al33g0oo4wi6q5fwdn0`
subscribe
- idx — BIGINT(20) — Primary key — NOT NULL
- is_delayed — BIT(1) — NOT NULL
- billing_key_idx — BIGINT(20) — Foreign key → billing_key.idx
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- version — BIGINT(20)
- user_id — VARCHAR(20) — Foreign key → user.id
- INDEX — `FKp2boy83tv72ahj9oo1ac1r334`
- INDEX — `FK31lkjb2x51cw4bljtmswtj6r`
subscribe_detail
- idx — BIGINT(20) — Primary key — NOT NULL
- period — INT(11)
- price — INT(11) — NOT NULL
- created_at — DATETIME(6)
- end_at — DATETIME(6)
- sale_idx — BIGINT(20) — Foreign key → sale.idx
- start_at — DATETIME(6)
- subscribe_idx — BIGINT(20) — Foreign key → subscribe.idx
- updated_at — DATETIME(6)
- version — BIGINT(20)
- status — ENUM('CANCELED', 'RETURNING', 'RETURN_REQUESTED', 'SUBSCRIBING') — NOT NULL
- INDEX — `FK70avgr568c6o2yyoq8fki7vye`
- INDEX — `FKacyskwm1a13cdmm17nfj2kyjs`
user
- id — VARCHAR(20) — Primary key — NOT NULL
- birth — DATE
- is_delayed — BIT(1) — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- name — VARCHAR(10) — NOT NULL
- phone_number — VARCHAR(20) — NOT NULL
- email — VARCHAR(50) — NOT NULL
- address1 — VARCHAR(100)
- address2 — VARCHAR(100)
- password — VARCHAR(256)
user_has_user_tag
- idx — BIGINT(20) — Primary key — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- user_tag_idx — BIGINT(20) — Foreign key → user_tag.idx
- condition_idx — VARCHAR(20) — Foreign key → user.id
- INDEX — `FKlg2cyi87yyincg032gk718ho3`
- INDEX — `FKlb5y30r6t6m7lmixssm02rxto`
user_tag
- idx — BIGINT(20) — Primary key — NOT NULL
- created_at — DATETIME(6)
- updated_at — DATETIME(6)