Joomak

Tables (42)

authority (권한)

  • auth_id (Key) — INT — Primary key — NOT NULL
  • auth_type (Field) — VARCHAR
  • auth_nm (Field2) — VARCHAR
  • auth_use_yn (Field3) — VARCHAR
  • sys_reg_at (Field5) — TIMESTAMP
  • sys_reg_id (Field6) — INT
  • sys_upd_at (Field7) — TIMESTAMP
  • sys_upd_id (Field8) — INT

badge_image (뱃지)

  • badge_id (Key) — INT — Primary key — NOT NULL
  • seq (Field) — INT
  • badge_img_url (Field2) — VARCHAR
  • badge_nm (Field3) — VARCHAR
  • badge_state (Field4) — VARCHAR
  • sys_reg_at (Field5) — TIMESTAMP
  • sys_reg_id (Field6) — INT
  • sys_upd_at (Field7) — TIMESTAMP
  • sys_upd_id (Field8) — INT

cart_base (카트)

  • cart_id (Key) — INT — Primary key — NOT NULL
  • mbr_id (Key2) — INT — Foreign key → member_base.mbr_id — NOT NULL
  • goods_id (Field) — INT
  • goods_cnt (Field2) — INT
  • goods_price (Field3) — INT
  • sys_reg_at (Field5) — TIMESTAMP
  • sys_reg_id (Field6) — INT
  • sys_upd_at (Field7) — TIMESTAMP
  • sys_upd_id (Field8) — INT

cart_option (카트 옵션 테이블)

  • cart_option_id (Key) — INT — Primary key — NOT NULL
  • cart_id (Key2) — INT — Foreign key → cart_base.cart_id — NOT NULL
  • option_id (Field) — INT
  • sys_reg_at (Field5) — TIMESTAMP
  • sys_reg_id (Field6) — INT
  • sys_upd_at (Field7) — TIMESTAMP
  • sys_upd_id (Field8) — INT

category (카테고리(공통))

  • ctgry_grp (Key) — VARCHAR — Primary key — NOT NULL
  • ctgry_rlsrc_id (Key2) — INT — Foreign key → category_related_search.ctgry_rlsrc_id — NOT NULL
  • ctgry_depth (Field) — INT
  • ctgry_use_yn (Field2) — VARCHAR
  • ctgry_nm (Field3) — VARCHAR
  • sys_reg_at (Field5) — TIMESTAMP
  • sys_reg_id (Field6) — INT
  • sys_upd_at (Field7) — TIMESTAMP
  • sys_upd_id (Field8) — INT

category_base (카테고리)

  • category_id (Key) — INT — Primary key — NOT NULL
  • store_id (Key2) — INT — Foreign key → store_base.store_id — NOT NULL
  • sys_reg_id (Field3) — INT
  • sys_reg_at (Field4) — TIMESTAMP
  • sys_upd_id (Field5) — INT
  • sys_upd_at (Field6) — TIMESTAMP
  • category_nm (Field) — VARCHAR

category_related_search (카테고리 연관 검색)

  • ctgry_rlsrc_id (Key) — INT — Primary key — NOT NULL
  • ctgry_up_id (Field) — INT
  • seq (Field2) — INT
  • ctgry_rlsrc_nm (Field3) — VARCHAR
  • ctgry_rlsrc_use_yn (Field4) — VARCHAR
  • sys_reg_at (Field5) — TIMESTAMP
  • sys_reg_id (Field6) — INT
  • sys_upd_at (Field7) — TIMESTAMP
  • sys_upd_id (Field8) — INT

code_detail (코드 상세)

  • code_grp (Key) — VARCHAR — Primary key — NOT NULL
  • code_grp_dtl (Field) — VARCHAR
  • code_nm (Field2) — VARCHAR
  • code_use_yn (Field3) — VARCHAR
  • sort_seq (Field4) — INT
  • sys_reg_at (Field5) — TIMESTAMP
  • sys_reg_id (Field6) — INT
  • sys_upd_at (Field7) — TIMESTAMP
  • sys_upd_id (Field8) — INT

comment (댓글)

  • comment_id (Key) — INT — Primary key — NOT NULL
  • review_id (Key2) — INT — Foreign key → review.review_id — NOT NULL
  • cooment_reg_id (Field2) — INT
  • content (Field3) — VARCHAR
  • comment_type (Field4) — VARCHAR
  • sys_reg_id (Field14) — INT
  • sys_reg_at (Field15) — TIMESTAMP
  • sys_upd_id (Field16) — INT
  • sys_upd_at (Field17) — TIMESTAMP

email_send_history (이메일 발송 이력)

  • email_id (Key) — INT — Primary key — NOT NULL
  • site_id (Key22) — INT — Foreign key → email_template.site_id — NOT NULL
  • template_id (Key2) — INT — Foreign key → email_template.template_id — NOT NULL
  • sender (Field) — VARCHAR(45)
  • receiver (Field2) — VARCHAR
  • email_content (Field3) — VARCHAR
  • email_snd_state (Field4) — VARCHAR
  • sys_reg_at (Field5) — TIMESTAMP
  • sys_reg_id (Field6) — INT
  • sys_upd_at (Field7) — TIMESTAMP
  • sys_upd_id (Field8) — INT

email_template (이메일 템플릿)

  • template_id (Key) — INT — Primary key — NOT NULL
  • site_id (Key2) — INT — Foreign key → site_info.site_id — NOT NULL
  • group_code (Field) — VARCHAR
  • template_nm (Field2) — VARCHAR(45)
  • template_info (Field3) — VARCHAR
  • template_script (Field4) — VARCHAR(600)
  • sys_reg_at (Field5) — TIMESTAMP
  • sys_reg_id (Field6) — INT
  • sys_upd_at (Field7) — TIMESTAMP
  • sys_upd_id (Field8) — INT

inventory (재고)

  • inventory_id (Key) — INT — Primary key — NOT NULL
  • menu_id (Key2) — INT — Foreign key → menu_base.menu_id — NOT NULL
  • inventory_quantity (Field) — INT
  • safety_inventory (Field2) — INT
  • sys_reg_id (Field3) — INT
  • sys_reg_at (Field4) — TIMESTAMP
  • sys_upd_id (Field5) — INT
  • sys_upd_at (Field6) — TIMESTAMP

like (공감)

  • like_id (Key) — INT — Primary key — NOT NULL
  • review_id (Key2) — INT — Foreign key → review.review_id — NOT NULL
  • review_reg_id (Field2) — INT
  • like_push_id (Field3) — INT
  • like_type (Field4) — VARCHAR
  • del_yn (Field6) — VARCHAR
  • sys_reg_id (Field14) — INT
  • sys_reg_at (Field15) — TIMESTAMP
  • sys_upd_id (Field16) — INT
  • sys_upd_at (Field17) — TIMESTAMP

member_banned (진상고객관리)

  • banned_id (Key) — INT — Primary key — NOT NULL
  • mbr_id (Key2) — INT — Foreign key → member_base.mbr_id — NOT NULL
  • banned_yn (Field) — CHAR
  • sys_reg_id (Field3) — INT
  • sys_reg_at (Field4) — TIMESTAMP
  • sys_upd_id (Field5) — INT
  • sys_upd_at (Field6) — TIMESTAMP

member_base (고객)

  • mbr_id (Key) — INT — Primary key — NOT NULL
  • mbr_nm (Field) — VARCHAR
  • mbr_stat_cd (Field2) — INT
  • login_id (Field3) — VARCHAR
  • sns_login_yn (Field4) — CHAR
  • birth (Field5) — VARCHAR
  • gender (Field6) — VARCHAR
  • email (Field7) — VARCHAR
  • mobile (Field8) — VARCHAR
  • password (Field9) — VARCHAR
  • joined_at (Field10) — TIMESTAMP
  • logined_at (Field11) — TIMESTAMP
  • login_failed_cnt (Field12) — INT
  • pw_changed_at (Field13) — TIMESTAMP
  • sys_reg_id (Field14) — INT
  • sys_reg_at (Field15) — TIMESTAMP
  • sys_upd_id (Field16) — INT
  • sys_upd_at (Field17) — TIMESTAMP
  • mbr_profile_img_path (Field18) — VARCHAR
  • nickname (Field19) — VARCHAR

member_delivery_address (주소지 설정)

  • address_id (Key) — INT — Primary key — NOT NULL
  • mbr_id (Key2) — INT — Foreign key → member_base.mbr_id — NOT NULL
  • parcel_based_address_basic (Field) — VARCHAR
  • parcel_based_address_detail (Field2) — VARCHAR
  • road_based_address_basic (Field7) — VARCHAR
  • road_based_address_detail (Field8) — VARCHAR
  • post_code (Field9) — VARCHAR
  • main_divr_address_yn (Field10) — CHAR
  • sys_reg_id (Field3) — INT
  • sys_reg_at (Field4) — TIMESTAMP
  • sys_upd_id (Field5) — INT
  • sys_upd_at (Field6) — TIMESTAMP

member_dormant (휴면계정관리)

  • dormant_id (Key) — INT — Primary key — NOT NULL
  • mbr_id (Key2) — INT — Foreign key → member_base.mbr_id — NOT NULL
  • dormant_strt_dt (Field) — TIMESTAMP
  • dormant_end_dt (Field2) — TIMESTAMP
  • sys_reg_id (Field3) — INT
  • sys_reg_at (Field4) — TIMESTAMP
  • sys_upd_id (Field5) — INT
  • sys_upd_at (Field6) — TIMESTAMP

member_grade (회원등급)

  • grade_id (Key) — INT — Primary key — NOT NULL
  • mbr_id (Key2) — INT — Foreign key → member_base.mbr_id — NOT NULL
  • benefit (Field10) — VARCHAR
  • sys_reg_id (Field3) — INT
  • sys_reg_at (Field4) — TIMESTAMP
  • sys_upd_id (Field5) — INT
  • sys_upd_at (Field6) — TIMESTAMP

member_requirement (요청사항)

  • req_id (Key) — INT — Primary key — NOT NULL
  • mbr_id (Key2) — INT — Foreign key → member_base.mbr_id — NOT NULL
  • req_to_rider (Field) — VARCHAR
  • req_rider_ytn (Field2) — CHAR
  • req_to_owner (Field7) — VARCHAR
  • req_owner_yn (Field8) — CHAR
  • sys_reg_id (Field3) — INT
  • sys_reg_at (Field4) — TIMESTAMP
  • sys_upd_id (Field5) — INT
  • sys_upd_at (Field6) — TIMESTAMP

member_store_interest (가게 찜하기)

  • interest_id (Key) — INT — Primary key — NOT NULL
  • store_id (Key2) — INT — Foreign key → store_base.store_id — NOT NULL
  • mbr_id (Key3) — INT — Foreign key → member_base.mbr_id — NOT NULL
  • sys_reg_id (Field3) — INT
  • sys_reg_at (Field4) — TIMESTAMP
  • sys_upd_id (Field5) — INT
  • sys_upd_at (Field6) — TIMESTAMP

menu_base (메뉴)

  • menu_id (Key) — INT — Primary key — NOT NULL
  • store_id (Key2) — INT — Foreign key → store_base.store_id — NOT NULL
  • menu_nm (Field2) — VARCHAR
  • menu_code (Field3) — VARCHAR
  • menu_stat (Field4) — VARCHAR
  • price (Field5) — INT
  • menu_component (Field6) — VARCHAR
  • menu_description (Field7) — VARCHAR
  • order_information (Field8) — VARCHAR
  • main_yn (Field9) — VARCHAR
  • opt_yn (Field) — VARCHAR
  • min_order_quantity (Field10) — INT
  • max_order_quantity (Field11) — INT
  • sales_start_at (Field12) — TIMESTAMP
  • sales_end_at (Field13) — TIMESTAMP
  • country_id (Field18) — INT
  • tag_badge (Field19) — VARCHAR
  • use_yn (Field20) — VARCHAR
  • del_yn (Field21) — VARCHAR
  • sys_reg_id (Field14) — INT
  • sys_reg_at (Field15) — TIMESTAMP
  • sys_upd_id (Field16) — INT
  • sys_upd_at (Field17) — TIMESTAMP

menu_group (메뉴 그룹)

  • menu_grp_id (Key) — INT — Primary key — NOT NULL
  • store_id (Key2) — INT — Foreign key → store_base.store_id — NOT NULL
  • menu_grp_nm (Field2) — VARCHAR
  • menu_grp_description (Field3) — VARCHAR
  • menu_grp_srt (Field4) — VARCHAR
  • del_yn (Field6) — VARCHAR
  • sys_reg_id (Field14) — INT
  • sys_reg_at (Field15) — TIMESTAMP
  • sys_upd_id (Field16) — INT
  • sys_upd_at (Field17) — TIMESTAMP

menu_image (메뉴 이미지)

  • menu_img_id (Key) — INT — Primary key — NOT NULL
  • menu_id (Key2) — INT — Foreign key → menu_base.menu_id — NOT NULL
  • img_srt (Field2) — INT
  • org_img_nm (Field3) — VARCHAR
  • dir_img_nm (Field4) — VARCHAR
  • img_path (Field5) — VARCHAR
  • del_yn (Field6) — VARCHAR
  • sys_reg_id (Field14) — INT
  • sys_reg_at (Field15) — TIMESTAMP
  • sys_upd_id (Field16) — INT
  • sys_upd_at (Field17) — TIMESTAMP

mg_list (맛객 일지)

  • mg_list_id (Key) — INT — Primary key — NOT NULL
  • mbr_id (Key2) — INT — Foreign key → member_base.mbr_id — NOT NULL
  • store_id (Key3) — INT — Foreign key → store_base.store_id — NOT NULL
  • ord_id (Field) — VARCHAR
  • content (Field2) — VARCHAR
  • order_time (Field7) — TIMESTAMP
  • grade (Field8) — DOUBLE
  • sys_reg_id (Field3) — INT
  • sys_reg_at (Field4) — TIMESTAMP
  • sys_upd_id (Field5) — INT
  • sys_upd_at (Field6) — TIMESTAMP

mg_list_image (맛객 일지 사진)

  • mg_img_id (Key) — INT — Primary key — NOT NULL
  • mg_list_id (Key2) — INT — Foreign key → mg_list.mg_list_id — NOT NULL
  • store_id (Key3) — VARCHAR — Foreign key → mg_list.store_id — NOT NULL
  • mg_list_img_path (Field9) — VARCHAR
  • sys_reg_id (Field3) — INT
  • sys_reg_at (Field4) — TIMESTAMP
  • sys_upd_id (Field5) — INT
  • sys_upd_at (Field6) — TIMESTAMP

option (옵션)

  • opt_id (Key) — INT — Primary key — NOT NULL
  • opt_grp_id (Key2) — INT — Foreign key → option_group.opt_grp_id — NOT NULL
  • opt_nm (Field) — VARCHAR
  • opt_price (Field2) — INT
  • opt_srt (Field7) — INT
  • use_yn (Field8) — VARCHAR
  • del_yn (Field9) — VARCHAR
  • sys_reg_id (Field3) — INT
  • sys_reg_at (Field4) — TIMESTAMP
  • sys_upd_id (Field5) — INT
  • sys_upd_at (Field6) — TIMESTAMP

option_group (옵션그룹)

  • opt_grp_id (Key) — INT — Primary key — NOT NULL
  • store_id (Key22) — INT — Foreign key → menu_base.store_id — NOT NULL
  • menu_id (Key2) — INT — Foreign key → menu_base.menu_id — NOT NULL
  • opt_grp_nm (Field) — VARCHAR
  • use_yn (Field2) — VARCHAR
  • del_yn (Field7) — VARCHAR
  • opt_req_yn (Field8) — VARCHAR
  • opt_grp_srt (Field9) — INT
  • sys_reg_id (Field3) — INT
  • sys_reg_at (Field4) — TIMESTAMP
  • sys_upd_id (Field5) — INT
  • sys_upd_at (Field6) — TIMESTAMP

order_base (주문)

  • order_id (Key) — INT — Primary key — NOT NULL
  • mbr_id (Key2) — INT — Foreign key → member_base.mbr_id — NOT NULL
  • store_id (Key3) — INT — Foreign key → store_base.store_id — NOT NULL
  • order_state_cd (Field2) — VARCHAR
  • rider_require (Field3) — VARCHAR
  • owner_require (Field4) — VARCHAR
  • order_complete_at (Field5) — DATETIME
  • order_cancel_at (Field6) — DATETIME
  • order_dlvr_start_at (Field7) — DATETIME
  • order_dlvr_complete_at (Field8) — DATETIME
  • rider_id (Field9) — LONG
  • sys_reg_id (Field14) — INT
  • sys_reg_at (Field15) — TIMESTAMP
  • sys_upd_id (Field16) — INT
  • sys_upd_at (Field17) — TIMESTAMP

order_dlvr_address (주문 배달 주소)

  • order_dlvr_add_id (Key) — INT — Primary key — NOT NULL
  • order_id (Key2) — INT — Foreign key → order_base.order_id — NOT NULL
  • address_id (Key3) — INT — Foreign key → member_delivery_address.address_id — NOT NULL
  • parcel_based_address_detail (Field2) — VARCHAR
  • road_based_address_detail (Field3) — VARCHAR
  • size_option (Field6) — VARCHAR
  • sys_reg_id (Field14) — INT
  • sys_reg_at (Field15) — TIMESTAMP
  • sys_upd_id (Field16) — INT
  • sys_upd_at (Field17) — TIMESTAMP

order_dtl (주문상세)

  • order_dtl_id (Key) — INT — Primary key — NOT NULL
  • order_id (Key2) — INT — Foreign key → order_base.order_id — NOT NULL
  • goods_id (Field2) — INT
  • goods_cnt (Field3) — INT
  • total_price (Field4) — LONG
  • opt_id (Field5) — INT
  • size_option (Field6) — VARCHAR
  • sys_reg_id (Field14) — INT
  • sys_reg_at (Field15) — TIMESTAMP
  • sys_upd_id (Field16) — INT
  • sys_upd_at (Field17) — TIMESTAMP

order_dtl_option (주문상세옵션)

  • order_dtl_option (Key) — INT — Primary key — NOT NULL
  • order_dtl_id (Key2) — INT — Foreign key → order_dtl.order_dtl_id — NOT NULL
  • opt_id (Field2) — INT
  • sys_reg_id (Field14) — INT
  • sys_reg_at (Field15) — TIMESTAMP
  • sys_upd_id (Field16) — INT
  • sys_upd_at (Field17) — TIMESTAMP

order_evaluate (주문평가)

  • order_evaluate_id (Key) — INT — Primary key — NOT NULL
  • order_id (Key2) — INT — Foreign key → order_base.order_id — NOT NULL
  • mbr_id (Key3) — INT — Foreign key → member_base.mbr_id — NOT NULL
  • order_rating (Field) — DOUBLE
  • order_comment (Field2) — VARCHAR
  • order_evaluate_img (Field3) — VARCHAR
  • del_yn (Field4) — VARCHAR
  • sys_reg_at (Field5) — TIMESTAMP
  • sys_reg_id (Field6) — INT
  • sys_upd_at (Field7) — TIMESTAMP
  • sys_upd_id (Field8) — INT

owner_base (점주)

  • onwer_id (Key) — INT — Primary key — NOT NULL
  • owner_nm (Field) — VARCHAR
  • login_id (Field2) — VARCHAR
  • birth (Field7) — VARCHAR
  • gender (Field8) — VARCHAR
  • email (Field9) — VARCHAR
  • mobile (Field10) — VARCHAR
  • password (Field11) — VARCHAR
  • joined_at (Field12) — TIMESTAMP
  • logged_in_at (Field13) — TIMESTAMP
  • login_failed_cnt (Field14) — INT
  • pw_changed_at (Field15) — TIMESTAMP
  • mbr_profile_img_path (Field16) — VARCHAR
  • sys_reg_id (Field3) — INT
  • sys_reg_at (Field4) — TIMESTAMP
  • sys_upd_id (Field5) — INT
  • sys_upd_at (Field6) — TIMESTAMP

pay_base (결제 베이스)

  • pay_id (Key) — INT — Primary key — NOT NULL
  • order_id (Key2) — INT — Foreign key → order_base.order_id — NOT NULL
  • mbr_id (Key3) — INT — Foreign key → member_base.mbr_id — NOT NULL
  • pay_state_cd (Field2) — VARCHAR
  • pay_type (Field3) — VARCHAR
  • code (Field4) — VARCHAR
  • method_result_code (Field5) — VARCHAR
  • method_result_message (Field6) — VARCHAR
  • aid (Field7) — VARCHAR
  • tid (Field8) — VARCHAR
  • cid (Field9) — VARCHAR
  • partner_order_id (Field) — VARCHAR
  • partner_user_id (Field10) — VARCHAR
  • payment_method_type (Field11) — VARCHAR
  • item_name (Field12) — VARCHAR
  • amount (Field13) — INT
  • card_type (Field18) — VARCHAR
  • card_mid (Field19) — VARCHAR
  • purchase_corp_code (Field20) — VARCHAR
  • issuer_corp_code (Field21) — VARCHAR
  • created_at (Field22) — VARCHAR
  • approved_at (Field23) — VARCHAR
  • sys_reg_id (Field14) — INT
  • sys_reg_at (Field15) — TIMESTAMP
  • sys_upd_id (Field16) — INT
  • sys_upd_at (Field17) — TIMESTAMP

provider (SNS로그인)

  • sns_id (Key) — INT — Primary key — NOT NULL
  • mbr_id (Key2) — INT — Foreign key → member_base.mbr_id — NOT NULL
  • sns_type (Field) — VARCHAR
  • sns_name (Field2) — VARCHAR
  • sns_email (Field7) — VARCHAR
  • sns_birth (Field8) — VARCHAR
  • sns_age (Field9) — VARCHAR
  • sys_reg_id (Field3) — INT
  • sys_reg_at (Field4) — TIMESTAMP
  • sys_upd_id (Field5) — INT
  • sys_upd_at (Field6) — TIMESTAMP
  • uid (Field10) — VARCHAR

review (리뷰)

  • review_id (Key) — INT — Primary key — NOT NULL
  • order_id (Key2) — INT — Foreign key → order_base.order_id — NOT NULL
  • store_id (Key3) — INT — Foreign key → store_base.store_id — NOT NULL
  • content (Field2) — VARCHAR
  • like_cnt (Field3) — INT
  • dislike_cnt (Field4) — INT
  • review_type (Field6) — VARCHAR
  • review_score (Field7) — INT
  • del_yn (Field8) — VARCHAR
  • del_id (Field9) — VARCHAR
  • del_reason (Field) — VARCHAR
  • sys_reg_id (Field14) — INT
  • sys_reg_at (Field15) — TIMESTAMP
  • sys_upd_id (Field16) — INT
  • sys_upd_at (Field17) — TIMESTAMP

review_image (리뷰이미지)

  • review_img_id (Key) — INT — Primary key — NOT NULL
  • review_id (Key2) — INT — Foreign key → review.review_id — NOT NULL
  • img_srt (Field2) — VARCHAR
  • org_img_nm (Field3) — VARCHAR
  • dir_img_nm (Field4) — VARCHAR
  • img_path (Field6) — INT
  • sys_reg_id (Field14) — INT
  • sys_reg_at (Field15) — TIMESTAMP
  • sys_upd_id (Field16) — INT
  • sys_upd_at (Field17) — TIMESTAMP

site_info (사이트 정보)

  • site_id (Key) — INT — Primary key — NOT NULL
  • site_nm (Field) — VARCHAR(45)
  • site_dtl (Field2) — VARCHAR
  • site_state (Field3) — VARCHAR
  • use_yn (Field4) — VARCHAR
  • use_start_at (Field9) — INT
  • access_code (Field10) — TIMESTAMP
  • site_url (Field11) — site_url
  • sys_reg_at (Field5) — TIMESTAMP
  • sys_reg_id (Field6) — INT
  • sys_upd_at (Field7) — TIMESTAMP
  • sys_upd_id (Field8) — INT

store_base (가게)

  • store_id (Key) — INT — Primary key — NOT NULL
  • onwer_id (Key2) — INT — Foreign key → owner_base.onwer_id — NOT NULL
  • store_nm (Field) — VARCHAR
  • grade (Field2) — DOUBLE
  • avg_dlvr_time (Field7) — VARCHAR
  • preview_store_intro (Field8) — VARCHAR
  • business_hour (Field9) — VARCHAR
  • store_main_cmt1 (Field10) — VARCHAR
  • store_main_cmt2 (Field11) — VARCHAR
  • sys_reg_id (Field3) — INT
  • sys_reg_at (Field4) — TIMESTAMP
  • sys_upd_id (Field5) — INT
  • sys_upd_at (Field6) — TIMESTAMP

store_goods (가게 상품)

  • goods_id (Key) — INT — Primary key — NOT NULL
  • store_id (Key2) — INT — Foreign key → store_base.store_id — NOT NULL
  • category_id (Key3) — INT — Foreign key → category_base.category_id — NOT NULL
  • sys_reg_id (Field3) — INT
  • sys_reg_at (Field4) — TIMESTAMP
  • sys_upd_id (Field5) — INT
  • sys_upd_at (Field6) — TIMESTAMP

store_image (가게 이미지)

  • store_img_id (Key) — INT — Primary key — NOT NULL
  • store_id (Key2) — VARCHAR — Foreign key → store_base.store_id — NOT NULL
  • store_img_path (Field) — VARCHAR
  • display_seq (Field2) — INT
  • display_yn (Field7) — CHAR
  • store_main_img (Field8) — VARCHAR
  • store_profile_img (Field9) — VARCHAR
  • sys_reg_id (Field3) — INT
  • sys_reg_at (Field4) — TIMESTAMP
  • sys_upd_id (Field5) — INT
  • sys_upd_at (Field6) — TIMESTAMP

store_review (매장 리뷰)

  • review_id (Key) — INT — Primary key — NOT NULL
  • store_id (Key2) — INT — Foreign key → store_base.store_id — NOT NULL
  • comment (Field) — VARCHAR
  • dwriter_gb (Field2) — VARCHAR
  • write_at (Field7) — TIMESTAMP
  • edit_at (Field8) — TIMESTAMP
  • delete_yn (Field9) — CHAR
  • delete_at (Field10) — TIMESTAMP
  • secret_yn (Field11) — CHAR
  • writer (Field3) — INT
  • ord_no (Field4) — VARCHAR