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)