의류 보관 서비스 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