panmun

Tables (30)

Book (Untitled8)

  • book_id (책 아이디) — varchar — Primary key — NOT NULL
  • publisher_code_id (출판사 코드 아이디) — varchar — Foreign key → PublisherCode.publisher_code_id — NOT NULL
  • classification_code_id (분류코드 아이디) — varchar — Foreign key → ClassificationCode.classification_code_id — NOT NULL
  • collectionId (컬랙션아이디) — varchar — Foreign key → Collection.collectionId — NOT NULL
  • writerId (작성자 아이디) — varchar — Foreign key → Collection.writerId — NOT NULL
  • role_id (역할 아이디) — varchar — Foreign key → Collection.role_id — NOT NULL
  • externalBookCategory (아이디3) — varchar — Foreign key → ExternalBookCategory.externalBookCategory — NOT NULL
  • bookCode (도서코드) — varchar
  • isbn10 (ISBN(10)) — varchar
  • isbn13 (ISBN(13)) — varchar
  • isbn (ISBN) — varchar
  • issn (ISSN) — varchar
  • titleR (도서명(R)) — varchar
  • titleO (도서명(O)) — varchar
  • subtitleK (부제(K)) — varchar
  • subtitleR (부제(R)) — varchar
  • counterpartSignatures (대등서명) — varchar
  • totalSignature (총서명) — varchar
  • authorK (저/편(K)) — varchar
  • authorR (저/편(R)) — varchar
  • foreignAuthorK (외저/편(K)) — varchar
  • foreignAuthorR (외저/편(R)) — varchar
  • translatorK (역K) — varchar
  • translatorR (역 R) — varchar
  • price (정가) — Decimal
  • publishAt (발행일자) — Date
  • plate (판형) — varchar
  • edition (판차) — varchar
  • countType (면수/권수) — enum
  • count (면수/권수 갯수) — Long
  • magazineType (단행본/잡지) — enum
  • isSet (set (default false)) — boolean
  • language (언어) — enum — Korean(디폴트), Bilingual, English, Japanese, Chinese, 기타 기타 선택 시 출판상황 드롭메뉴 우측으로 기타 내용 입력폼이 생김
  • status (일시품절, 절판, 출고, 기타) — enum
  • statusDescription (기타 선택 시 내용) — varchar
  • isSale (판매 여부(Default true)) — boolean
  • cycle (간기(연간, 반년간, 계간, 격월간, 월간, 비정기)) — status
  • specifics (특이사항) — varchar
  • InternalSpecifics (특이사항(내부)) — varchar
  • coverImageUrl (표지 이미지) — varchar
  • description (책소개) — varchar
  • bookIndex (목차) — varchar
  • citation (본문 인용) — varchar
  • review (서평) — varchar
  • authorIntroduction (저자소개) — varchar
  • Field

ClassificationCode (Untitled7)

  • classification_code_id (분류코드 아이디) — varchar — Primary key — NOT NULL
  • name (분류 이름) — varchar
  • code (분류 코드) — varchar
  • createdAt (생성날짜) — Date
  • updatedAt (수정날짜) — Date
  • Field

Collection (Untitled9)

  • collectionId (컬랙션아이디) — varchar — Primary key — NOT NULL
  • writerId (작성자 아이디) — varchar — Foreign key → Manager.manager_id — NOT NULL
  • role_id (역할 아이디) — varchar — Foreign key → Manager.role_id — NOT NULL
  • approverId (승인자아이디) — varchar
  • name (컬랙션이름) — varchar
  • createdAt (작성일) — Date
  • approvedAt (승인일) — Date
  • status (승인상태(피드백요청, 피드백중, 승인완료)) — varchar
  • memo (내부 참고용 메모) — varchar
  • Field

ExternalBookCategory (Untitled24)

  • externalBookCategory (아이디) — varchar — Primary key — NOT NULL
  • source (출처(교보, 전상망 등)) — enum
  • name (이름) — varchar
  • type (외부도서, 판문도서 (PENDING, APPROVE))

Group (Untitled13)

  • groupId (그룹아이디) — varchar — Primary key — NOT NULL
  • name (그룹이름) — varchar
  • Field

MailLog (Untitled22)

  • mailLogId (이메일 전송 로그 id) — long — Primary key — NOT NULL
  • manager_id (관리자 아이디) — varchar — Foreign key → Manager.manager_id — NOT NULL
  • memberId (거래처아이디) — varchar — Foreign key → Member.memberId — NOT NULL
  • role_id (역할 아이디) — varchar — Foreign key → Manager.role_id — NOT NULL
  • type (타입 (견적서, 주문, 인보이스)) — enum
  • mailedAt (이메일 전송한 시간) — date
  • Field

Manager (Untitled)

  • manager_id (관리자 아이디) — varchar — Primary key — NOT NULL
  • role_id (역할 아이디) — varchar — Foreign key → Role.role_id — NOT NULL
  • name (이름) — varchar
  • role (직위) — varchar
  • email (이메일) — varchar
  • username (아이디) — varchar
  • password (비밀번호) — varchar
  • Field

Member (Untitled11)

  • memberId (거래처아이디) — varchar — Primary key — NOT NULL
  • responsibility (담당자명) — varchar
  • email (담당자 이메일) — varchar
  • phoneNumber (담당자 연락처) — varchar
  • department (소속) — varchar
  • address (주소) — varchar
  • status (가입승인, 승인 완료) — enum
  • memo (메모) — varchar
  • code (기존회원코드) — varchar
  • password (비밀번호) — varchar
  • memo (고객 관련 메모) — varchar
  • Field

MemberCategory (Untitled23)

  • memberCategoryId (회원카테고리 설정 아이디) — varchar — Primary key — NOT NULL
  • memberId (거래처아이디) — varchar — Foreign key → Member.memberId — NOT NULL
  • type (타입) — enum
  • name (이름) — varchar
  • Field
  • Field2
  • Field3
  • Field4

MemberGroup (Untitled12)

  • memberGroupId (고객-그룹 아이디) — varchar — Primary key — NOT NULL
  • memberId (거래처아이디) — varchar — Foreign key → Member.memberId — NOT NULL
  • groupId (그룹아이디) — varchar — Foreign key → Group.groupId — NOT NULL

MemberTab (Untitled16)

  • memberTabId (거래처-탭 아이디) — varchar — Primary key — NOT NULL
  • memberId (거래처아이디) — varchar — Foreign key → Member.memberId — NOT NULL
  • tabId (탭 아이디) — varchar — Foreign key → tab.tabId — NOT NULL
  • sectionId (섹션 아이디) — varchar — Foreign key → tab.sectionId — NOT NULL

MidumCategory (Untitled2)

  • medium_category_id (중분류아이디) — varchar — Primary key — NOT NULL
  • policy_id (정책 아이디) — varchar — Foreign key → Policy.policy_id — NOT NULL
  • name (중분류 이름) — varchar
  • type (중분류 타입) — enum
  • Field

Notification (Untitled17)

  • notificationId (공지 아이디) — varchar — Primary key — NOT NULL
  • manager_id (작성자 아이디) — varchar — Foreign key → Manager.manager_id — NOT NULL
  • role_id (역할 아이디) — varchar — Foreign key → Manager.role_id — NOT NULL
  • title (제목) — varchar
  • content (내용) — varchar
  • createdAt (작성일) — Date
  • Field

NotificationGroup (Untitled19)

  • notificationGroupId (아이디) — varchar — Primary key — NOT NULL
  • notificationId (공지 아이디) — varchar — Foreign key → Notification.notificationId — NOT NULL
  • groupId (그룹아이디) — varchar — Foreign key → Group.groupId — NOT NULL
  • role_id (역할 아이디) — varchar — Foreign key → Notification.role_id — NOT NULL

NotificationMember (Untitled18)

  • notificationMemberId (Key) — varchar — Primary key — NOT NULL
  • memberId (거래처아이디) — varchar — Foreign key → Member.memberId — NOT NULL
  • notificationId (공지 아이디) — varchar — Foreign key → Notification.notificationId — NOT NULL
  • manager_id (작성자 아이디) — varchar — Foreign key → Notification.manager_id — NOT NULL
  • role_id (역할 아이디) — varchar — Foreign key → Notification.role_id — NOT NULL
  • Field

OrderDetail (CopyOfUntitled21)

  • ordersDetailId (상세주문아이디) — varchar — Primary key — NOT NULL
  • book_id (책 아이디) — varchar — Foreign key → Book.book_id — NOT NULL
  • orderId (주문아이디2) — varchar — Foreign key → Orders.orderId — NOT NULL
  • memberId (거래처아이디) — varchar — Foreign key → Orders.memberId — NOT NULL
  • manager_id (관리자 아이디) — varchar — Foreign key → Orders.manager_id — NOT NULL
  • role_id (역할 아이디) — varchar — Foreign key → Book.role_id — NOT NULL
  • externalBookCategory (아이디3) — varchar — Foreign key → Book.externalBookCategory — NOT NULL
  • price (판매가격 (초기값은 원래 가격)) — double
  • quantity (수량) — long
  • message (메세지) — varchar
  • Field

Orders (CopyOfUntitled20)

  • orderId (주문아이디) — varchar — Primary key — NOT NULL
  • memberId (거래처아이디) — varchar — Foreign key → Member.memberId — NOT NULL
  • manager_id (관리자 아이디) — varchar — Foreign key → Manager.manager_id — NOT NULL
  • role_id (역할 아이디) — varchar — Foreign key → Manager.role_id — NOT NULL
  • orderCode (주문번호) — varchar
  • requirement (요청사항) — varchar
  • quotationFile (견적서(url)) — varchar
  • orderFormFile (주문서(url)) — varchar
  • invoiceFile (인보이스(url)) — varchar
  • quotatedAt (견적 요청일) — Date
  • status (현황(작성, 완료, 전달)) — enum
  • mailedAt (메일전송일) — Date
  • Field

Policy (Untitled4)

  • policy_id (정책 아이디) — varchar — Primary key — NOT NULL
  • category (대분류) — enum — 도서관리 컬랙션관리 거래처관리 주문관리 코드관리 관리자
  • name (정책이름) — varchar
  • Field

PublisherCode (Untitled5)

  • publisher_code_id (출판사 코드 아이디) — varchar — Primary key — NOT NULL
  • code (출판사 코드) — varchar
  • rName (출판사명 R) — varchar
  • kName (출판사명 K) — varchar
  • oName (출판사명 O) — varchar
  • createdAt (생성날짜) — Date
  • updatedAt (수정날짜) — Date
  • Field

Quotation (Untitled20)

  • quotationId (견적서아이디) — varchar — Primary key — NOT NULL
  • memberId (거래처아이디) — varchar — Foreign key → Member.memberId — NOT NULL
  • manager_id (관리자 아이디) — varchar — Foreign key → Manager.manager_id — NOT NULL
  • role_id (역할 아이디) — varchar — Foreign key → Manager.role_id — NOT NULL
  • orderCode (주문번호) — varchar
  • requirement (요청사항) — varchar
  • quotationFile (견적서(url)) — varchar
  • orderFormFile (주문서(url)) — varchar
  • Field2
  • quotatedAt (견적 요청일) — Date
  • status (현황(작성, 완료, 전달)) — enum
  • mailedAt (메일전송일) — Date
  • Field

QuotationDetail (Untitled21)

  • ordersDetailId (상세주문아이디) — varchar — Primary key — NOT NULL
  • quotationId (견적서 아이디) — varchar — Foreign key → Quotation.quotationId — NOT NULL
  • memberId (거래처아이디) — varchar — Foreign key → Quotation.memberId — NOT NULL
  • book_id (책 아이디) — varchar — Foreign key → Book.book_id — NOT NULL
  • manager_id (관리자 아이디) — varchar — Foreign key → Quotation.manager_id — NOT NULL
  • role_id (역할 아이디) — varchar — Foreign key → Book.role_id — NOT NULL
  • externalBookCategory (아이디3) — varchar — Foreign key → Book.externalBookCategory — NOT NULL
  • price (판매가격 (초기값은 원래 가격)) — double
  • quantity (수량) — long
  • message (메세지) — varchar
  • Field

Role (Untitled3)

  • role_id (역할 아이디) — varchar — Primary key — NOT NULL
  • manager_id (관리자 아이디2) — varchar — Foreign key — NOT NULL
  • name (역할 이름) — varchar
  • memo (메모) — varchar
  • Field

RoleDetail (Untitled6)

  • role_detail_id (역할 상세 내용 아이디) — varchar — Primary key — NOT NULL
  • role_id (역할 아이디) — varchar — Foreign key → Role.role_id — NOT NULL
  • manager_id (관리자 아이디2) — varchar — Foreign key → Role.manager_id — NOT NULL
  • policy_id (대분류 아이디) — varchar
  • mediumCategoryId (중분류 아이디) — varchar
  • subCategoryId (소분류 아이디) — varchar
  • Field

Section

  • sectionId (섹션 아이디) — varchar — Primary key — NOT NULL
  • name (섹션명) — varchar
  • Field

SectionCollection (.)

  • sectionCollectionId (아이디) — varchar — Primary key — NOT NULL
  • collectionId (컬랙션아이디) — varchar — Foreign key → Collection.collectionId — NOT NULL
  • sectionId (섹션 아이디) — varchar — Foreign key → Section.sectionId — NOT NULL
  • role_id (역할 아이디) — varchar — Foreign key → Collection.role_id — NOT NULL
  • Field

SubCategory (subCategory)

  • sub_category_id (소분류 아이디) — varchar — Primary key — NOT NULL
  • medium_category_id (중분류아이디) — varchar — Foreign key → MidumCategory.medium_category_id — NOT NULL
  • policy_id (정책아이디)
  • name (소분류 이름) — varchar
  • type (소분류 권한 종류 (조회, 등록, 삭제,수정, 피드백)) — enum
  • Field

TabGroup (Untitled15)

  • tabGroupId (탭-그룹아이디) — varchar — Primary key — NOT NULL
  • tabId (탭 아이디) — varchar — Foreign key → tab.tabId — NOT NULL
  • groupId (그룹아이디) — varchar — Foreign key → Group.groupId — NOT NULL
  • sectionId (섹션 아이디) — varchar — Foreign key → tab.sectionId — NOT NULL

TabGroupCollection (Untitled25)

  • Key — Primary key — NOT NULL
  • tabGroupId (탭-그룹아이디) — varchar — Foreign key → TabGroup.tabGroupId — NOT NULL
  • collectionId (컬랙션아이디) — varchar — Foreign key → Collection.collectionId — NOT NULL
  • memo (메모) — varchar
  • Field

feedback (Untitled10)

  • feedbackId (피드백아이디) — varchar — Primary key — NOT NULL
  • writerId (작성자아이디) — varchar — Foreign key → Manager.manager_id — NOT NULL
  • role_id (역할 아이디) — varchar — Foreign key → Manager.role_id — NOT NULL
  • createdAt (작성일자) — Date
  • content (내용) — varchar
  • isRead (읽은 피드백인지 확인) — boolean
  • Field

tab (Untitled14)

  • tabId (탭 아이디) — varchar — Primary key — NOT NULL
  • sectionId (섹션 아이디) — varchar — Foreign key → Section.sectionId — NOT NULL
  • name (탭 이름) — varchar
  • memo (메모) — varchar
  • Field