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