OKPOS

Tables (22)

Notice (NoticePartner)

  • id — BIGINT — Primary key — NOT NULL — 공지사항
  • category — VARCAHAR(10) — enumerated 사용하면 좋을 듯?
  • title — VARCHAR(100)
  • content — TEXT — 내용을 pdf형식으로 올리는 걸까 / 텍스트로 올리는걸까
  • image — TEXT
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(15)

NoticeFile (NoticeFilePartner)

  • id — BIGINT — Primary key — NOT NULL — 공지사항 첨부파일
  • url (주소) — TEXT
  • capacity — INT
  • noticeId — INT — Foreign key → Notice.id — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(15)

applicants (Applicants)

  • id — BIGINT — Primary key — NOT NULL — 교육신청자
  • name — VARCHAR
  • email — VARCHAR
  • mobilePhoneNum — VARCHAR
  • registrationId — INT — Foreign key → registration.id — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(15)

application (Application)

  • id — BIGINT — Primary key — NOT NULL — 대리점 / 딜러 지원 식별번호
  • category — VARCHAR — ENUM
  • name — VARCHAR
  • email — VARCHAR
  • phoneNum — VARCHAR
  • isExperience — BOOLEAN — 영업경력 여부
  • NoticeId — INT — Foreign key → Notice.id — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(15)

dataRoom (DataRoomPartner)

  • id — BIGINT — Primary key — NOT NULL — 자료실 자료
  • category — VARCHAR(10)
  • title — VARCHAR(100)
  • content — TEXT
  • image — TEXT
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(15)

dataRoomFile (DataRoomFilePartner)

  • id — BIGINT — Primary key — NOT NULL — 자료실 자료 첨부파일
  • url — TEXT
  • capacity — INT — 용량
  • dataRoomId — INT — Foreign key → dataRoom.id — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(15)

educationSchedule (EducationSchedule)

  • id — BIGINT — Primary key — NOT NULL — 교육일정
  • title — VARCHAR(30)
  • content — TEXT
  • image — TEXT
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(15)

educationScheduleFile (EducationScheduleFile)

  • id — BIGINT — Primary key — NOT NULL — 교육일정 첨부파일
  • url — TEXT
  • capacity — INT
  • educationScheduleId — INT — Foreign key → educationSchedule.id — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(15)

inquiry (InquiryPartner)

  • id — BIGINT — Primary key — NOT NULL — 문의
  • category — VARCHAR
  • title — VARCHAR
  • content — TEXT
  • status (replyStatus) — TINYINT
  • userId (consumerId) — INT — Foreign key → userPartner.Id — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(15)

inquiryFile (InquiryFilePartner)

  • id — BIGINT — Primary key — NOT NULL — 문의 첨부파일
  • url — TEXT
  • inquiryId — INT — Foreign key → inquiry.id — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(15)

inquiryReply (InquiryReplyPartner)

  • inquiryId — BIGINT — Foreign key → inquiry.id — NOT NULL — 문의 답변
  • content — TEXT
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(15)

item (Item)

  • id — BIGINT — Primary key — NOT NULL — 상품
  • category — VARCHAR(15)
  • image — TEXT
  • lineUp — VARCHAR(15)
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(15)

maintenance (Maintenance)

  • id — BIGINT — Primary key — NOT NULL — 유지보수 신청
  • crn (certificateNum) — VARCHAR(15)
  • businessName — VARCHAR(20)
  • representativeName — VARCHAR(10)
  • mobilePhoneNum — VARCHAR(12)
  • phoneNum — VARCHAR(12)
  • email — TEXT
  • address — TEXT
  • maintenanceCategory — TINYINT
  • userId — INT — Foreign key → userPartner.Id — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(15)

partnerBanner (BannerPartner)

  • id — BIGINT — Primary key — NOT NULL — 파트너 롤링배너
  • title — VARCHAR
  • image — TEXT
  • content — VARCHAR
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(15)

partnerComposition (CompositionPartner)

  • id — BIGINT — Primary key — NOT NULL — 상품 구성요소
  • category — VARCHAR — ENUM?
  • content — TEXT
  • itemId — INT — Foreign key → item.id — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(15)

partnerOrder (OrderPartner)

  • id — BIGINT — Primary key — NOT NULL — 발주 신청
  • businessName (buisnessName) — VARCHAR(20)
  • crn — VARCHAR(15)
  • representativeName — VARCHAR(10)
  • mobilePhoneNum — VARCHAR(12)
  • phoneNum — VARCHAR(12)
  • email — TEXT
  • address — TEXT
  • recieve — TINYINT
  • taxBillEmail — TEXT
  • processingStatus — VARCHAR(15) — ENUM 예상
  • partnerOrderPrice — INT
  • userId — INT — Foreign key → userPartner.Id — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(15)

partnerOrderItem (OrderItemPartner)

  • id — BIGINT — Primary key — NOT NULL — 발주 상품
  • quantity — INT
  • price — INT
  • partnerOrderId — INT — Foreign key → partnerOrder.id — NOT NULL
  • partnerCompositionId — INT — Foreign key → partnerComposition.id — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(15)

registration (Registration)

  • id — BIGINT — Primary key — NOT NULL — 교육신청
  • registrationNoticeId — INT — Foreign key → registrationNotice.id — NOT NULL
  • agencyName — VARCHAR
  • phoneNum — VARCHAR
  • address — TEXT
  • educationDate — TIMESTAMP — 교육일자
  • applicantsNum — INT
  • name — VARCHAR
  • email — TEXT
  • mobilePhoneNum — VARCHAR
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(15)

registrationNotice (RegistrationNotice)

  • id — BIGINT — Primary key — NOT NULL — 교육신청 공고
  • title — VARCHAR(30)
  • content — TEXT
  • image — TEXT
  • start — TIMESTAMP — 접수시작일
  • deadline — TIMESTAMP — 접수마감일
  • place — VARCHAR
  • educationDate — TIMESTAMP — 교육일자
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(15)

registrationNoticeFile (RegistrationNoticeFile)

  • id — BIGINT — Primary key — NOT NULL — 교육신청 공고 첨부파일
  • url — TEXT
  • capacity — INT
  • registrationNoticeId — INT — Foreign key → registrationNotice.id — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(15)

subBanner (SubBannerPartner)

  • id — BIGINT — Primary key — NOT NULL — 파트너 롤링서브배너
  • title — VARCHAR
  • image — TEXT
  • content — VARCHAR
  • bannerId — INT — Foreign key → partnerBanner.id — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(15)

userPartner (UserInfoPartner)

  • Id (id) — BIGINT — Primary key — NOT NULL — 파트너 유저
  • userName (username) — VARCHAR(6)
  • phoneNum — VARCHAR(12)
  • password — TEXT — 해싱해서 저장할 듯
  • crn (certificateNum) — VARCHAR(15) — 사업자 등록 번호
  • business_name (businessName) — VARCHAR(20)
  • crf (certificateFile) — TEXT — 사업자 등록증 (s3에 올리는걸로 판단)
  • address — TEXT
  • withdrawalCategory — VARCHAR — ENUM
  • withdrawalReson — TEXT
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR