의류 보관 서비스 ERD

테이블 (22)

billing_info

  • id — bigserial — 기본 키 — NOT NULL
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • deletedAt — timestamptz
  • description — int4 — NOT NULL
  • isActive — bool — NOT NULL
  • price — int4 — NOT NULL

carrier_type

  • code — varchar(100) — 기본 키 — NOT NULL
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • deletedAt — timestamptz
  • name — varchar(100) — NOT NULL

clothing

  • id — bigserial — 기본 키 — NOT NULL
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • deletedAt — timestamptz
  • sortWeight — int4 — NOT NULL
  • name — varchar(100) — NOT NULL
  • thumbnailImage — varchar — NOT NULL
  • image — varchar — NOT NULL
  • stateCode — varchar — NOT NULL
  • typeCode — varchar — NOT NULL
  • storageGroupId — int8 — NOT NULL

clothing_state

  • code — varchar(100) — 기본 키 — NOT NULL
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • deletedAt — timestamptz
  • name — varchar(100) — NOT NULL

clothing_type

  • code — varchar(100) — 기본 키 — NOT NULL
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • deletedAt — timestamptz
  • name — varchar(100) — NOT NULL

contract

  • id — bigserial — 기본 키 — NOT NULL
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • deletedAt — timestamptz
  • name — varchar(100) — NOT NULL
  • phone — varchar(50) — NOT NULL
  • email — varchar(100) — NOT NULL
  • carrierTypeCode — varchar — NOT NULL
  • storageId — int8 — NOT NULL

contract_delivery

  • id — bigserial — 기본 키 — NOT NULL
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • deletedAt — timestamptz
  • zipcode — varchar(10) — NOT NULL
  • address — varchar — NOT NULL
  • detailAddress — varchar
  • pickupMessage — varchar
  • delivertId — varchar
  • pickupTypeCode — varchar — NOT NULL
  • meansTypeCode — varchar — NOT NULL
  • contractId — int8 — NOT NULL

delivery

  • id — bigserial — 기본 키 — NOT NULL
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • deletedAt — timestamptz
  • sortWeight — int4 — NOT NULL
  • name — varchar(100) — NOT NULL
  • zipcode — varchar(10) — NOT NULL
  • address — varchar — NOT NULL
  • detailAddress — varchar
  • pickupMessage — varchar
  • userUid — int8 — NOT NULL
  • userId — int8

discount_info

  • id — bigserial — 기본 키 — NOT NULL
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • deletedAt — timestamptz
  • description — int4 — NOT NULL
  • isActive — bool — NOT NULL
  • discountPrice — int4
  • discountRate — int4
  • maxDiscountPrice — int4
  • minDiscountPrice — int4
  • startDate — timestamptz
  • endDate — timestamptz
  • typeCode — varchar — NOT NULL
  • paymentId — int8 — NOT NULL

discount_type

  • code — varchar(100) — 기본 키 — NOT NULL
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • deletedAt — timestamptz
  • name — varchar(100) — NOT NULL

means_type

  • code — varchar(100) — 기본 키 — NOT NULL
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • deletedAt — timestamptz
  • name — varchar(100) — NOT NULL

payment

  • id — bigserial — 기본 키 — NOT NULL
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • deletedAt — timestamptz
  • step — int4 — NOT NULL
  • monthPrice — int4 — NOT NULL
  • discountPrice — int4 — NOT NULL
  • billingPrice — int4 — NOT NULL
  • billingAt — timestamptz — NOT NULL
  • paidPrice — int4
  • paidAt — timestamptz
  • payResponse — varchar
  • stateCode — varchar — NOT NULL
  • storageId — int8 — NOT NULL
  • cardInfoId — int8 — NOT NULL

payment_card_entity

  • id — bigserial — 기본 키 — NOT NULL
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • deletedAt — timestamptz
  • cardNumber — varchar(16) — NOT NULL
  • expirationDate — varchar(5) — NOT NULL
  • ownerName — varchar(100) — NOT NULL
  • userId — int8 — NOT NULL

payment_state

  • code — varchar(100) — 기본 키 — NOT NULL
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • deletedAt — timestamptz
  • name — varchar(100) — NOT NULL

pickup_type

  • code — varchar(100) — 기본 키 — NOT NULL
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • deletedAt — timestamptz
  • name — varchar(100) — NOT NULL

reclaim

  • id — bigserial — 기본 키 — NOT NULL
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • deletedAt — timestamptz
  • userUid — int8 — NOT NULL
  • deliveryImages — _text — NOT NULL
  • reclaimApplyAt — timestamptz — NOT NULL
  • reclaimCompleteAt — timestamptz
  • note — varchar
  • stateCode — varchar — NOT NULL
  • storageId — int8 — NOT NULL

reclaim_clothing

  • id — bigserial — 기본 키 — NOT NULL
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • deletedAt — timestamptz
  • name — varchar(100) — NOT NULL
  • thumbnailImage — varchar — NOT NULL
  • image — varchar — NOT NULL
  • stateCode — varchar — NOT NULL
  • typeCode — varchar — NOT NULL
  • reclaimeId — int8 — NOT NULL

reclaim_delivery

  • id — bigserial — 기본 키 — NOT NULL
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • deletedAt — timestamptz
  • zipcode — varchar(10) — NOT NULL
  • address — varchar — NOT NULL
  • detailAddress — varchar
  • reclaimMessage — varchar
  • pickupTypeCode — varchar — NOT NULL
  • meansTypeCode — varchar — NOT NULL
  • reclaimId — int8 — NOT NULL

reclaim_state

  • code — varchar(100) — 기본 키 — NOT NULL
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • deletedAt — timestamptz
  • name — varchar(100) — NOT NULL

storage

  • id — bigserial — 기본 키 — NOT NULL
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • deletedAt — timestamptz
  • monthPrice — int4 — NOT NULL
  • payDays — int4 — NOT NULL
  • contractStep — int4 — NOT NULL
  • deliveryImages — _text — NOT NULL
  • contractStartAt — timestamptz
  • contractEndAt — timestamptz
  • endStep — int4
  • note — varchar
  • stateCode — varchar — NOT NULL
  • billingInfoId — int8 — NOT NULL
  • userUid — int8 — NOT NULL
  • userId — int8

storage_group

  • id — bigserial — 기본 키 — NOT NULL
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • deletedAt — timestamptz
  • name — varchar(100) — NOT NULL
  • storageId — int8 — NOT NULL

storage_state

  • code — varchar(100) — 기본 키 — NOT NULL
  • createdAt — timestamptz — NOT NULL
  • updatedAt — timestamptz — NOT NULL
  • deletedAt — timestamptz
  • name — varchar(100) — NOT NULL