화담 결제 DB

테이블 (17)

Admin

  • id — text — NOT NULL
  • password — text — NOT NULL
  • name — text — NOT NULL

Category

  • id — serial4 — 기본 키 — NOT NULL
  • name — text — NOT NULL

Check_Shop_Valid

  • id — text — 기본 키 — NOT NULL
  • registration — text
  • business_report — text
  • bank_book — text
  • shop_front — text
  • shop_inner — text
  • shop_id — text
  • reject_reason — text

CustomProduct (CopyOfProduct)

  • id — 기본 키 — NOT NULL
  • shop_id — text — 외래 키 → Product.shop_id — NOT NULL
  • price — float8 — NOT NULL
  • name — text — NOT NULL
  • simple_explain — text — NOT NULL
  • origin — text — NOT NULL
  • sale — bool — NOT NULL
  • category_id — int4 — NOT NULL
  • status

Custom_Flower

  • id — text — 기본 키 — NOT NULL
  • pick_up_date — text — NOT NULL
  • pick_up_time — text — NOT NULL
  • price — float8 — NOT NULL
  • quantity — int4 — NOT NULL
  • type — text — NOT NULL
  • color — text — NOT NULL
  • purpose — text — NOT NULL
  • keyword — text — NOT NULL
  • require — text — NOT NULL
  • recipient — text — NOT NULL

Flower_Descript_Image

  • id — text — 기본 키 — NOT NULL
  • url — text — NOT NULL
  • represent_id — text

Flower_Image

  • id — text — 기본 키 — NOT NULL
  • url — text — NOT NULL
  • represent_id — text

Order (Untitled2)

  • id — 기본 키 — NOT NULL
  • user_id — text — 외래 키 → User.id — NOT NULL
  • payment_id — 외래 키 → Payment.페이먼트키 — NOT NULL
  • total_price
  • create_at

OrderProduct (Untitled)

  • id (Key) — 기본 키 — NOT NULL
  • order_id — 외래 키 → Order.id — NOT NULL
  • user_id — text — 외래 키 → User.id — NOT NULL
  • product_id — text — 외래 키 → Product.id — NOT NULL
  • custom_product_id — 외래 키 → CustomProduct.id — NOT NULL
  • pick_up_date
  • amount

Owner

  • id — text — 기본 키 — NOT NULL
  • email — text — NOT NULL
  • password — text — NOT NULL
  • name — text — NOT NULL
  • birth — int4 — NOT NULL
  • phone_number — text — NOT NULL
  • profile_url — text
  • created_at — timestamp(3) — NOT NULL
  • hashedRt — text

Payment

  • 페이먼트키 (paymentKey) — String — 기본 키 — NOT NULL
  • 버젼 (version) — String
  • 결제타입 (type) — String
  • 주문ID (orderId) — String
  • 상점아이디 (mId) — String
  • 통화 (currency) — String
  • 결제수단 (method) — String
  • 총결제금액 (totalAmount) — Number
  • 잔고 (balanceAmount) — Number
  • 결제상태 (status) — Date
  • 결제날짜 (requestedAt) — Date
  • 승인날짜 (approvedAt) — Date
  • 거래키값 (lastTransactionKey) — String
  • 공급가액 (suppliedAmount) — Number
  • 부가세 (vat) — Number
  • 면세금액 (taxFreeAmount) — Number
  • 결제금액(세금제외) (taxExemptionAmount) — Number
  • 취소금액 (cancelAmount) — Number
  • 취소이유 (cancelReason) — Number
  • Field17
  • Field18
  • Field19
  • Field20
  • Field21
  • Field22

Product

  • id — text — 기본 키 — NOT NULL
  • shop_id — text — 외래 키 → Shop.id — NOT NULL
  • price — float8 — NOT NULL
  • name — text — NOT NULL
  • simple_explain — text — NOT NULL
  • origin — text — NOT NULL
  • sale — bool — NOT NULL
  • category_id — int4 — NOT NULL

Review

  • id — serial4 — 기본 키 — NOT NULL
  • rating — int4 — NOT NULL
  • writer_id — text — NOT NULL
  • store_id — text — NOT NULL
  • text — text
  • created_at — timestamp(3) — NOT NULL

Review_Image

  • id — text — 기본 키 — NOT NULL
  • review_id — int4 — NOT NULL
  • image_url — text — NOT NULL
  • created_at — timestamp(3) — NOT NULL

Review_Reply

  • id — text — 기본 키 — NOT NULL
  • review_id — int4 — NOT NULL
  • store_id — text — NOT NULL
  • text — text — NOT NULL
  • created_at — timestamp(3) — NOT NULL

Shop

  • id — text — 기본 키 — NOT NULL
  • name — text — NOT NULL
  • introduction — text
  • open_time — text — NOT NULL
  • close_time — text — NOT NULL
  • shop_number — text — NOT NULL
  • personal_number — text — NOT NULL
  • latitude — float8
  • longitude — float8
  • address — text — NOT NULL
  • detail_address — text — NOT NULL
  • check_shop_valid_id — text
  • owner_id — text
  • sell — bool — NOT NULL
  • atelier — bool — NOT NULL
  • classroom — bool — NOT NULL
  • etc — bool — NOT NULL
  • mon — bool — NOT NULL
  • tue — bool — NOT NULL
  • wed — bool — NOT NULL
  • thu — bool — NOT NULL
  • fri — bool — NOT NULL
  • sat — bool — NOT NULL
  • sun — bool — NOT NULL
  • permission — bool

User

  • id — text — 기본 키 — NOT NULL
  • email — text — NOT NULL
  • password — text — NOT NULL
  • name — text — NOT NULL
  • nickname — text — NOT NULL
  • birth — int4 — NOT NULL
  • phone_number — text — NOT NULL
  • profile_url — text
  • apple_auth — bool — NOT NULL
  • google_auth — bool — NOT NULL
  • naver_auth — bool — NOT NULL
  • kakao_auth — bool — NOT NULL
  • created_at — timestamp(3) — NOT NULL
  • hashedRt — text