Ssofun Project ERD
Tables (52)
tb_admin (Untitled32)
- admin_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- biz_id (Key2) — BIGINT — Foreign key → tb_biz.biz_id — tb_biz
- login_account (Field3) — VARCHAR(120) — NOT NULL — 계정명
- login_password (Field4) — VARCHAR(120) — NOT NULL — 비밀번호
- admin_nickname (Field5) — VARCHAR(60)
- admin_phone (Field6) — VARCHAR(60)
- admin_received_report (Field7) — VARCHAR(20) — 통신판매업신고여부
- admin_report_description (Field8) — VARCHAR(60) — 신고번호
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_biz (회사이름)
- biz_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- biz_name (Field3) — VARCHAR(120) — 회사명
- biz_no (Field4) — CHAR(10) — 사업자번호
- biz_phone (Field6) — VARCHAR(11) — 회사 전화번호
- biz_ceo (Field5) — VARCHAR(30) — 대표자명
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_cart (Untitled26)
- cart_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- user_id (Key2) — BIGINT — Foreign key → tb_user.user_id — NOT NULL — tb_user
- product_id (Key3) — BIGINT — Foreign key → tb_product.product_id — NOT NULL — tb_product
- count (Field3) — INT — NOT NULL — 수량
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_community (CopyOfUntitled45)
- community_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- community_category_id (Key2) — BIGINT — Foreign key → tb_community_category.community_category_id — NOT NULL — Auto Increment
- user_id (Key3) — BIGINT — Foreign key → tb_user.user_id — NOT NULL — Auto Increment
- title (Field) — VARCHAR(500) — NOT NULL — 제목
- contents (Field2) — VARCHAR(2000) — NOT NULL — 내용
- read_count (Field3) — INT
- created_at (Field4) — DATETIME — NOT NULL
- used_fg (Field5) — INT — NOT NULL
tb_community_category (CopyOfUntitled46)
- community_category_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- name (Field3) — VARCHAR(200) — NOT NULL — 카테고리명
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_community_comment (CopyOfUntitled452)
- community_comment_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- community_id (Key2) — BIGINT — Foreign key → tb_community.community_id — NOT NULL — Auto Increment
- user_id (Key3) — BIGINT — Foreign key → tb_user.user_id — NOT NULL — Auto Increment
- parent_id (Key4) — BIGINT — Foreign key → tb_community_comment.community_comment_id — Auto Increment
- comment (Field) — VARCHAR(500) — NOT NULL — 댓글
- created_at (Field2) — DATETIME — NOT NULL
- used_fg (Field3) — INT — NOT NULL
tb_community_image (CopyOfUntitled40)
- community_image_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- community_id (Key2) — BIGINT — Foreign key → tb_community.community_id — NOT NULL — Auto Increment
- url (Field) — VARCHAR(120) — NOT NULL — 이미지 이름
- order_list (Field2) — INT — NOT NULL — 정렬순서
- created_at (Field3) — DATETIME — NOT NULL
- used_fg (Field4) — INT — NOT NULL
tb_community_like (CopyOfCopyOfUntitled452)
- community_like_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- community_id (Key2) — BIGINT — Foreign key → tb_community.community_id — NOT NULL — Auto Increment
- user_id (Key3) — BIGINT — Foreign key → tb_user.user_id — NOT NULL — Auto Increment
- created_at (Field3) — DATETIME — NOT NULL
- used_fg (Field4) — INT — NOT NULL
tb_community_notice (CopyOfUntitled44)
- community_notice_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- admin_id (Key3) — BIGINT — Foreign key → tb_admin.admin_id — NOT NULL — tb_admin
- title (Field3) — VARCHAR(200) — NOT NULL — 공지사항 제목
- contents (Field4) — VARCHAR(2000) — NOT NULL — 공지사항 내용
- read_count (Field) — INT
- created_at (Field2) — DATETIME — NOT NULL
- used_fg (Field5) — INT — NOT NULL
tb_delivery (Untitled15)
- delivery_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- delivery_company_id (Key2) — BIGINT — Foreign key → tb_delivery_company.delivery_company_id — NOT NULL — tb_delivery_company
- delivery_status_id (Key3) — BIGINT — Foreign key → tb_delivery_status.delivery_status_id — NOT NULL — tb_delivery_status
- delivery_recipient_id (Key4) — BIGINT — Foreign key → tb_delivery_recipient.delivery_recipient_id — NOT NULL — tb_delivery_recipient
- invoice_no (Field7) — VARCHAR(200) — NOT NULL — 운송장번호
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_delivery_company (Untitled16)
- delivery_company_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- code (Field3) — VARCHAR(100) — NOT NULL — 택배사 코드
- name (Field4) — VARCHAR(100) — NOT NULL — 택배사 이름
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_delivery_recipient (Untitled42)
- delivery_recipient_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- name (Field3) — VARHAR(32) — NOT NULL — 받는 이
- phone (Field4) — VARCHAR(11) — NOT NULL — 받는이 전화번호
- address_post (Field5) — CHAR(5) — NOT NULL — 우편번호
- address_default (Field6) — VARCHAR(200) — NOT NULL — 기본주소
- address_detail (Field7) — VARCHAR(300) — NOT NULL — 상세주소
- request_message (Field8) — VARCHAR(100) — 배송요청사항
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_delivery_status (Untitled36)
- delivery_status_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- name (Field3) — VARCHAR(120) — NOT NULL — 상태이름
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_funding (Untitled3)
- funding_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- funding_category_id (Key2) — BIGINT — Foreign key → tb_funding_category.funding_category_id — NOT NULL — tb_funding_category
- funding_tag_id (Key3) — BIGINT — Foreign key → tb_funding_tag.funding_tag_id — NOT NULL — tb_funding_tag
- user_creator_id (Key4) — BIGINT — Foreign key → tb_user_creator.user_creator_id — NOT NULL — tb_user_creator
- funding_code (Field10) — VARCHAR(100) — NOT NULL — 프로젝트 코드
- title (Field3) — VARCHAR(100) — NOT NULL — 제목
- description (Field5) — VARCHAR(500) — 제목 아래 설명
- contents (Field4) — VARCHAR(2000) — 상세설명 (HTML)
- attained_close_fg (Field6) — INT — NOT NULL — 목표 달성 시 종료
- target_price (Field12) — BIGINT — NOT NULL — 목표 금액
- confirm_fg (Field8) — INT — NOT NULL — 0 : 미승인 / 1 : 승인
- adult_fg (Field9) — INT — NOT NULL — 19세 전용 여부
- delivery_from (Field11) — DATETIME — NOT NULL — 배송 시작 예정일
- attained_at (Field7) — DATETIME — 목표달성일
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_funding_category (Untitled9)
- funding_category_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- name (Field3) — VARCHAR(64) — NOT NULL — 카테고리명
- image_url (Field4) — VARCHAR(200) — 아이콘
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_funding_favorit (Untitled8)
- funding_favorit_id (Key) — BIGINT — Primary key — NOT NULL — Auto Incremenet
- funding_id (Key2) — BIGINT — Foreign key → tb_funding.funding_id — NOT NULL — tb_funding
- user_id (Key3) — BIGINT — Foreign key → tb_user.user_id — NOT NULL — tb_user
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_funding_news (Untitled11)
- funding_notice_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- funding_id (Key2) — BIGINT — Foreign key → tb_funding.funding_id — NOT NULL — tb_funding
- title (Field3) — VARCHAR(300) — NOT NULL — 제목
- contents (Field4) — VARCHAR(2000) — NOT NULL — 내용
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_funding_news_review (Untitled12)
- funding_news_review_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- funding_notice_id (Key2) — BIGINT — Foreign key → tb_funding_news.funding_notice_id — NOT NULL — tb_funding_news
- user_id (Key3) — BIGINT — Foreign key → tb_user.user_id — NOT NULL — tb_user
- this_answer_id (Key4) — BIGINT — Foreign key → tb_funding_news_review.funding_news_review_id — 답글일 경우
- contents (Field3) — VARCHAR(500) — NOT NULL — 내용
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_funding_order (Untitled4)
- funding_order_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- user_id (Key2) — BIGINT — Foreign key → tb_user.user_id — NOT NULL — tb_user
- funding_order_status_id (Key3) — BIGINT — Foreign key → tb_funding_order_status.funding_order_status_id — NOT NULL — tb_funding_order_status
- price_support (Field3) — INT — NOT NULL — 추가 후원 금액
- open_name_fg (Field4) — INT — NOT NULL — 이름 공개 / 비공개
- open_amount_fg (Field5) — INT — NOT NULL — 금액 공개 / 비공개
- total_price (Field6) — INT — NOT NULL — 총 금액
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_funding_order_payment (Untitled20)
- payment_id (Key) — BIGINT — Foreign key → tb_payment.payment_id — NOT NULL — tb_payment
- funding_order_id (Key2) — BIGINT — Foreign key → tb_funding_order.funding_order_id — NOT NULL — tb_funding_order
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_funding_order_status (Untitled43)
- funding_order_status_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- name (Field3) — VARCHAR(100) — NOT NULL — 상태의 이름
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_funding_reopen_request (Untitled18)
- funding_reopen_request_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- user_id (Key2) — BIGINT — Foreign key → tb_user.user_id — NOT NULL — tb_user
- funding_id (Key3) — BIGINT — Foreign key → tb_funding.funding_id — NOT NULL — tb_funding
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_funding_review (Untitled13)
- funding_review_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- user_id (Key2) — BIGINT — Foreign key → tb_user.user_id — NOT NULL — tb_user
- funding_id (Key3) — BIGINT — Foreign key → tb_funding.funding_id — NOT NULL — tb_funding
- answer_this_id (Key4) — BIGINT — Foreign key → tb_funding_review.funding_review_id — 답글일 경우
- contents (Field3) — VARCHAR(500) — NOT NULL — 댓글내용
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_funding_reward (Untitled6)
- funding_reward_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- funding_id (Key2) — BIGINT — Foreign key → tb_funding.funding_id — NOT NULL — tb_funding
- title (Field3) — VARCHAR(120) — NOT NULL — 리워드제목
- description (Field6) — VARCHAR(500) — 리워드설명
- price (Field4) — INT — NOT NULL — 리워드 가격
- delivery_price (Field10) — INT — NOT NULL — 배달비
- target_sell_count (Field12) — INT — 판매 목표 개수
- stock_max (Field5) — INT — 최대 재고
- buy_count (Field9) — INT — 1인 최대구매개수
- start_from (Field7) — DATETIME — 시작일
- close_at (Field8) — DATETIME — 종료일
- delivery_from (Field13) — DATETIME — NOT NULL — 배송 시작일
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_funding_reward_item (Untitled23)
- funding_reward_item_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- funding_reward_id (Key2) — BIGINT — Foreign key → tb_funding_reward.funding_reward_id — NOT NULL — tb_funding_reward
- name (Field3) — VARCHAR(120) — NOT NULL — 이름
- count (Field4) — INT — NOT NULL — 상품의 개수
- used_fg (Field) — INT — NOT NULL
- created_at (Field2) — DATETIME — NOT NULL
tb_funding_reward_order (Untitled7)
- funding_reward_order_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- funding_reward_id (Key2) — BIGINT — Foreign key → tb_funding_reward.funding_reward_id — NOT NULL — tb_funding_reward
- funding_order_id (Key4) — BIGINT — Foreign key → tb_funding_order.funding_order_id — NOT NULL — tb_funding_order
- delivery_recipient_id (Key3) — BIGINT — Foreign key → tb_delivery_recipient.delivery_recipient_id — NOT NULL — tb_delivery_recipient
- count (Field5) — INT — NOT NULL — 구매 수량
- amount (Field3) — INT — NOT NULL — 금액
- status (Field4) — INT — NOT NULL — 주문 상태
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_funding_tag (Untitled10)
- funding_tag_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- name (Field3) — VARCHAR(64) — NOT NULL — 태그명
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_funding_thumbnail (Untitled5)
- funding_thumbnail_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- funding_id (Key2) — BIGINT — Foreign key → tb_funding.funding_id — NOT NULL — tb_funding
- url (Field3) — VARCHAR(200) — NOT NULL — 파일명
- image_order (Field4) — INT — NOT NULL — ORDER BY 순서
- created_at (Field) — INT — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_notice (Untitled44)
- notice_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- admin_id (Key3) — BIGINT — Foreign key → tb_admin.admin_id — NOT NULL — tb_admin
- notice_category_id (Key2) — BIGINT — Foreign key → tb_notice_category.notice_category_id — NOT NULL — tb_notice_category
- title (Field3) — VARCHAR(200) — NOT NULL — 공지사항 제목
- contents (Field4) — VARCHAR(2000) — NOT NULL — 공지사항 내용
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_notice_category (Untitled46)
- notice_category_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- name (Field3) — VARCHAR(200) — NOT NULL — 카테고리명
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_notice_reply (Untitled45)
- notice_reply_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- notice_id (Key2) — BIGINT — Foreign key → tb_notice.notice_id — NOT NULL — tb_notice
- user_id (Key3) — BIGINT — Foreign key → tb_user.user_id — NOT NULL — tb_user
- parent_id (Key4) — BIGINT — Foreign key → tb_notice_reply.notice_reply_id — 답글일 경우
- contents (Field3) — VARCHAR(500) — NOT NULL — 내용
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_payment (Untitled19)
- payment_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- amount (Field3) — BIGINT — NOT NULL — 금액
- description (Field4) — VARCHAR(1000) — 설명
- token (Field6) — VARCHAR(120) — NOT NULL — API의 토큰
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_product (Untitled24)
- product_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- admin_id (Key2) — BIGINT — Foreign key → tb_admin.admin_id — NOT NULL — tb_admin
- name (Field3) — VARCHAR(200) — NOT NULL — 상품의 이름
- price (Field4) — INT — NOT NULL — 상품의 가격
- price_sale (Field6) — INT — 상품의 할인가
- contents (Field5) — VARCHAR(2000) — 상세보기 내용
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_product_category (Untitled25)
- product_category_type_id (Key) — BIGINT — Foreign key → tb_product_category_type.product_category_type_id — NOT NULL — tb_product_category_type
- product_id (Key2) — BIGINT — Foreign key → tb_product.product_id — NOT NULL — tb_product
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_product_category_type (Untitled28)
- product_category_type_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- this_parent_id (Key2) — BIGINT — Foreign key → tb_product_category_type.product_category_type_id — 상위 카테고리
- node (Field3) — INT — NOT NULL — 최상위 0
- name (Field4) — VARCHAR(60) — NOT NULL — 카테고리명
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_product_detail_image (CopyOfUntitled31)
- product_detail_image_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- product_id (Key2) — BIGINT — Foreign key → tb_product.product_id — NOT NULL — tb_product
- name (Field3) — VARCHAR(200) — NOT NULL — 파일의 이름 (확장자포함)
- order_list (Field4) — INT — NOT NULL — 높은 순서대로 앞에 보여짐
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_product_favorit (Untitled41)
- product_favorit_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- product_id (Key2) — BIGINT — Foreign key → tb_product.product_id — NOT NULL — tb_product
- user_id (Key3) — BIGINT — Foreign key → tb_user.user_id — NOT NULL — tb_user
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_product_order (Untitled27)
- product_order_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- user_id (Key2) — BIGINT — Foreign key → tb_user.user_id — NOT NULL — tb_user
- amount (Field3) — INT — NOT NULL — 주문의 총 가격
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_product_order_item (Untitled30)
- product_order_item_id (Key4) — BIGINT — Primary key — NOT NULL — Auto Increment
- product_order_id (Key) — BIGINT — Foreign key → tb_product_order.product_order_id — NOT NULL — tb_product_order
- product_id (Key2) — BIGINT — Foreign key → tb_product.product_id — NOT NULL — tb_product
- product_order_status_id (Key5) — BIGINT — Foreign key → tb_product_order_status.product_order_status_id — NOT NULL — Auto Increment
- delivery_recipient_id (Key3) — BIGINT — Foreign key → tb_delivery_recipient.delivery_recipient_id — NOT NULL — tb_delivery_recipient
- count (Field3) — INT — NOT NULL — 개수
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_product_order_item_refund (Untitled38)
- product_order_item_refund_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- product_order_item_id (Key4) — BIGINT — Foreign key → tb_product_order_item.product_order_item_id — NOT NULL — tb_product_order_item
- refund_reason (Field3) — VARCHAR(120) — 환불사유
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_product_order_payment (Untitled29)
- payment_id (Key2) — BIGINT — Foreign key → tb_payment.payment_id — NOT NULL — tb_payment
- product_order_id (Key3) — BIGINT — Foreign key → tb_product_order.product_order_id — NOT NULL — tb_product_order
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_product_order_status (Untitled35)
- product_order_status_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- name (Field3) — VARCHAR(120) — NOT NULL — 상태이름
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_product_review (Untitled34)
- product_review_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- product_order_item_id (Key4) — BIGINT — Foreign key → tb_product_order_item.product_order_item_id — NOT NULL — tb_product_order_item
- user_id (Key2) — BIGINT — Foreign key → tb_user.user_id — NOT NULL — tb_user
- rate (Field4) — INT — NOT NULL — 별점
- contents (Field3) — VARCHAR(500) — 리뷰내용
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_product_review_image (Untitled37)
- product_review_image_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- product_review_id (Key2) — BIGINT — Foreign key → tb_product_review.product_review_id — NOT NULL — Auto Increment
- url (Field3) — VARCHAR(120) — NOT NULL — 파일명
- order_list (Field4) — INT — NOT NULL — 표시되는순서
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_product_thumbnail (Untitled31)
- product_thumbnail_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- product_id (Key2) — BIGINT — Foreign key → tb_product.product_id — NOT NULL — tb_product
- name (Field3) — VARCHAR(200) — NOT NULL — 파일의 이름 (확장자포함)
- order_list (Field4) — INT — NOT NULL — 높은 순서대로 앞에 보여짐
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_qna (Untitled39)
- qna_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- admin_id (Key2) — BIGINT — Foreign key → tb_admin.admin_id — tb_admin
- user_id (Key3) — BIGINT — Foreign key → tb_user.user_id — NOT NULL — tb_user
- biz_id (Field6) — BIGINT — 업체번호
- title (Field5) — VARCHAR(500) — NOT NULL — 문의제목
- contents (Field3) — VARCHAR(2000) — NOT NULL — 문의내용
- answer_contents (Field4) — VARCHAR(2000) — 답변내용
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_qna_image (Untitled40)
- qna_image_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- qna_id (Key2) — BIGINT — Foreign key → tb_qna.qna_id — NOT NULL — tb_qna
- url (Field3) — VARCHAR(120) — NOT NULL — 이미지 이름
- order_list (Field4) — INT — NOT NULL — 정렬순서
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_user (Untitled)
- user_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- user_phone_auth_id (Key2) — BIGINT — Foreign key → tb_user_phone_auth.user_phone_auth_id — tb_user_phone_auth
- email (Field3) — VARCHAR(64) — NOT NULL — 이메일 (아이디)
- password (Field4) — VARCHAR(64) — 비밀번호
- token (Field5) — VARCHAR(200) — OAuth2 토큰 (네이버, 카카오)
- name (Field6) — VARCHAR(200) — 성명
- nickname (Field7) — VARCHAR(200) — 닉네임
- agree_sms (Field9) — INT — NOT NULL — SMS 수신 동의
- created_at (Field) — DATETIME — NOT NULL — 생성일
- used_fg (Field2) — INT — NOT NULL — 회원상태
tb_user_address (Untitled14)
- user_delivery_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- user_id (Key2) — BIGINT — Foreign key → tb_user.user_id — NOT NULL — tb_user
- recipient_name (Field3) — VARCHAR(32) — 받으시는 분
- phone (Field8) — VARCHAR(12) — NOT NULL — 핸드폰번호
- address_post (Field6) — CHAR(5) — NOT NULL — 우편번호
- address_default (Field4) — VARCHAR(200) — NOT NULL — 기본 주소
- address_detail (Field5) — VARCHAR(300) — NOT NULL — 상세 주소
- request_message (Field7) — VARCHAR(100) — NOT NULL — 배달 요청사항
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_user_creator (Untitled21)
- user_creator_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- user_id (Key2) — BIGINT — Foreign key → tb_user.user_id — NOT NULL — tb_user
- name (Field4) — VARCHAR(60) — NOT NULL — 대표자명
- email (Field5) — VARCHAR(120) — NOT NULL — 대표자 이메일
- phone (Field6) — VARCHAR(11) — NOT NULL — 대표자 핸드폰번호
- creator_type (Field3) — INT — NOT NULL — 0: 개인사업자/ 1: 법인사업자
- biz_no (Field7) — CHAR(10) — 법인번호
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL
tb_user_creator_bank (Untitled22)
- user_creator_bank (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- user_creator_id (Key2) — BIGINT — Foreign key → tb_user_creator.user_creator_id — NOT NULL — tb_user_creator
- bank_type (Field4) — INT — NOT NULL — 은행 타입
- account_no (Field3) — VARCHAR(100) — NOT NULL — 통장번호
- account_name (Field5) — VARCHAR(60) — NOT NULL — 예금주명
- created_at (Field2) — DATETIME — NOT NULL
- used_fg (Field) — INT — NOT NULL
tb_user_phone_auth (Untitled17)
- user_phone_auth_id (Key) — BIGINT — Primary key — NOT NULL — Auto Increment
- phone (Field5) — VARCHAR(11) — NOT NULL — 핸드폰번호
- token (Field3) — VARCHAR(128) — NOT NULL
- isSuccess (Field4) — INT — NOT NULL — 핸드폰 인증 성공 여부
- created_at (Field) — DATETIME — NOT NULL
- used_fg (Field2) — INT — NOT NULL