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