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