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