데이터베이스 테이블 구조 다이어그램

테이블 관계 다이어그램

루트 테이블 (166개): 다른 테이블에 의해 외래키로 참조되지 않는 독립적인 테이블입니다.
ASIS_COLLECT ROOT
ASIS_CUSTOMER ROOT
ASIS_CUSTOMER_IDX ROOT
ASIS_CUSTOMER_PRICE_GROUP ROOT
ASIS_DIST_ORDER ROOT
ASIS_DIST_ORDER_01 ROOT
ASIS_DIST_ORDER_PRODUCT ROOT
ASIS_GREEN_ORDER ROOT
ASIS_GREEN_ORDER_PRODUCT ROOT
ASIS_ORDER ROOT
ASIS_ORDER_GN ROOT
ASIS_ORDER_PRODUCT ROOT
ASIS_PG_PAYMENT ROOT
ASIS_PRICE_GROUP ROOT
ASIS_PROCUCT_PURCHASE_PRICE ROOT
ASIS_PRODUCT ROOT
ASIS_PRODUCT_NUMBER ROOT
ASIS_PRODUCT_PRICE ROOT
ASIS_PURCHASE ROOT
ASIS_PURCHASE_01 ROOT
ASIS_SALE_LIMIT_PRODUCT ROOT
ASIS_SALE_LIMIT_PRODUCT_TMP ROOT
ASIS_SALE_UNIT_PRICE ROOT
ASIS_UNIT_PRICR_GROUP ROOT
ASIS_USER ROOT
BMF_ALERT_MESSAGE ROOT
BMF_ARCHIVE ROOT
BMF_ATTACH_FILES ROOT
BMF_BATCH_JOB ROOT
BMF_BATCH_JOB_LOG ROOT
BMF_BIZ_PLACE ROOT
BMF_BIZ_PLACE_BUDGET ROOT
BMF_BIZ_PLACE_DISTRIBUTION_RATE ROOT
BMF_BRANCH ROOT
BMF_CERT ROOT
BMF_CLAIM_CATEGORY ROOT
BMF_CLAIM_TYPE ROOT
BMF_CODE_GROUPS ROOT
BMF_CODE_ITEMS ROOT
BMF_CONNECTION_LOG ROOT
BMF_CUSTOMER ROOT
BMF_CUSTOMER_GROUP ROOT
BMF_CUSTOMER_GROUP_MEMBER ROOT
BMF_DELIVERY_ENTP ROOT
BMF_DEPOSIT ROOT
BMF_DEPOSIT_HISTORY ROOT
BMF_EMAIL_LOG ROOT
BMF_ESTIMATE ROOT
BMF_ESTIMATE_UNIT_PRODUCT ROOT
BMF_FAQ ROOT
BMF_INQUIRY_TEMPLATE ROOT
BMF_LATELY_VIEW_PRODUCT ROOT
BMF_LIVESTOCK_CERT ROOT
BMF_MENUS ROOT
BMF_MENU_AUTH_MEMBER ROOT
BMF_MENU_LOG ROOT
BMF_MENU_PROPERIES ROOT
BMF_MESSAGE_SEND_LOG ROOT
BMF_MESSAGE_TEMPLATE ROOT
BMF_NOTICES ROOT
BMF_PUSH_MESSAGES ROOT
BMF_QUOTATION_REQUEST ROOT
BMF_QUOTATION_REQUEST_UNIT_PRODUCT ROOT
BMF_REFUND_ACCOUNT ROOT
BMF_ROLE ROOT
BMF_ROLE_MEMBER ROOT
BMF_SEARCH_HISTORY ROOT
BMF_SEARCH_WORD ROOT
BMF_SEQUENCE ROOT
BMF_TENANT_WORK_CALENDAR ROOT
BMF_TOKEN ROOT
BMF_TRANSACTION_LOG ROOT
BMF_USER ROOT
BMF_USER_TEMP ROOT
BMF_WORK_CALENDAR ROOT
CMF_SURVEY ROOT
CMF_SURVEY_ANSWER ROOT
CMF_SURVEY_EXCLUDE_SUBJECT ROOT
CMF_SURVEY_ITEMS ROOT
CMF_SURVEY_QUESTION ROOT
CMF_SURVEY_QUESTION_ANSWER ROOT
CMF_SURVEY_SUBJECT ROOT
EMF_EVENT ROOT
EMF_EVENT_PRODUCT ROOT
IMF_INITIAL_INVENTORY ROOT
IMF_INITIAL_INVENTORY_TEMP ROOT
IMF_INITIAL_INVENTORY_UPLOAD ROOT
IMF_INVENTORY ROOT
IMF_RECEIPT_PAYMENT ROOT
IMF_STOCKTAKING ROOT
LOAD_TEST ROOT
MMF_MENU ROOT
MMF_MENU_PLAN ROOT
MMF_MENU_PLAN_MENU ROOT
MMF_MENU_PLAN_RECIPE ROOT
MMF_MENU_RECIPE ROOT
OMF_CLAIM ROOT
OMF_COLLECTION ROOT
OMF_COLLECT_MONEY ROOT
OMF_ECO_ORDER ROOT
OMF_ORDER ROOT
OMF_ORDER_COPY ROOT
OMF_ORDER_COPY_TEMP ROOT
OMF_ORDER_PAYMENT ROOT
OMF_ORDER_PRODUCT ROOT
OMF_ORDER_PRODUCT_COPY ROOT
OMF_ORDER_PRODUCT_HISTORY ROOT
OMF_ORDER_STATUS_HISTORY ROOT
OMF_ORDER_TEMP ROOT
OMF_PAYMENT_COMMISSION ROOT
OMF_PG_PAYMENT ROOT
OMF_PURCHASE_UNIT_PRICE_HISTORY ROOT
OMF_TAX_INVOICE ROOT
ORDER_REMARK_BACKUP_20251201 ROOT
PMF_BOOKMARK ROOT
PMF_BRAND ROOT
PMF_CERT ROOT
PMF_CUSTOMER_CATEGORY_MARGIN ROOT
PMF_CUSTOMER_MARGIN_TEMP ROOT
PMF_CUSTOMER_PRODUCT_MARGIN ROOT
PMF_INQUIRY ROOT
PMF_MAKER ROOT
PMF_ORIGIN ROOT
PMF_PRODUCT ROOT
PMF_PRODUCT_BASE_PRICE ROOT
PMF_PRODUCT_BASE_PRICE_TEMP ROOT
PMF_PRODUCT_CATEGORY ROOT
PMF_PRODUCT_CERT ROOT
PMF_PRODUCT_IMAGE ROOT
PMF_PRODUCT_PURCHASE_PRICE ROOT
PMF_PRODUCT_PURCHASE_PRICE_TEMP ROOT
PMF_PRODUCT_RESTRICT_TEMP ROOT
PMF_PRODUCT_SALE_PRICE ROOT
PMF_PRODUCT_TAG_TEMPLATE ROOT
PMF_SALE_LIMIT_PRODUCT ROOT
PMF_SALE_LIMIT_PRODUCT_TMP ROOT
PMF_SALE_PRICE_RATE ROOT
PMF_SALE_PRICE_RATE_TEMP ROOT
PMF_SUPPLIER_PRODUCT_INFO ROOT
PMF_UNIT_PRICE_GROUP ROOT
PMF_UNIT_PRICE_GROUP_MARGIN ROOT
PMF_UNIT_PRICE_GROUP_MARGIN_TEMP ROOT
POM_ANIMAL_PRODUCTS_TRACEABILITY ROOT
POM_PURCHASE_ORDER ROOT
POM_PURCHASE_ORDER_PRODUCT ROOT
POM_PURCHASE_PAYMENT ROOT
POM_PURCHASE_TAX_INVOICE ROOT
SMF_CUSTOMER_ORDER_PRODUCT_STAT ROOT
TEST_TABLE ROOT
TMF_ACCOUNT ROOT
TMF_ASSIGN_DELIVERY_ENTP ROOT
TMF_CONSIGN_ENTP ROOT
TMF_DELIVERY_COURSE ROOT
TMF_PRIVACY_MANAGER ROOT
TMF_TENANT ROOT
TMF_TERMS ROOT
TMF_TRANS_CERT_FILE ROOT
TMF_WAREHOUSE ROOT
TMF_WAREHOUSE_01 ROOT
TOBE_PURCHASE_PRICE ROOT
auth_group_permissions ROOT
auth_user_groups ROOT
auth_user_user_permissions ROOT
django_admin_log ROOT
django_migrations ROOT
django_session ROOT

외래키 관계 목록

참조하는 테이블 컬럼 참조되는 테이블 컬럼
auth_group_permissions group_id auth_group id
auth_group_permissions permission_id auth_permission id
auth_permission content_type_id django_content_type id
auth_user_groups group_id auth_group id
auth_user_groups user_id auth_user id
auth_user_user_permissions permission_id auth_permission id
auth_user_user_permissions user_id auth_user id
django_admin_log content_type_id django_content_type id
django_admin_log user_id auth_user id