콜렉트팝

테이블 (3)

declaration(신고테이블) (declaration)

  • did — number — 기본 키
  • fid (fid2) — number — 외래 키
  • userId — number — 외래 키
  • dleid — number — NOT NULL
  • decnum — number
  • regDate — date

payment(카카오페이 결제) (payment)

  • payment_id — NUMBER — 기본 키
  • userId — number — 외래 키
  • merchant_uid — VARCHAR2(255)
  • product_name — VARCHAR2(255)
  • amount — NUMBER
  • buyer_email — VARCHAR2(255)
  • buyer_name — VARCHAR2(255)
  • payment_status — VARCHAR2(50)
  • payment_date_time — TIMESTAMP

storerequest(등업신청테이블) (storerequest)

  • requestid — number — 기본 키
  • userId — number — 외래 키
  • companyname — varchar2(100)
  • bossname — VARCHAR2(50)
  • content — VARCHAR2(2000)
  • businessregistrationnumber — VARCHAR2(50)
  • contactnumber — VARCHAR2(30)
  • document1 — VARCHAR2(500)
  • document2 — VARCHAR2(500)
  • document3 — VARCHAR2(500)
  • requestReg — date