songsong

Tables (40)

FAQ (Untitled10)

  • faq_id (Key) — long — Primary key — NOT NULL
  • admin_id (Key2) — long — Foreign key → admin.admin_id — NOT NULL
  • faq_title (Field) — varchar
  • fiq_content (Field2) — varchar
  • faq_category (Field3) — varchar
  • view_count (Field4) — int
  • is_activation (Field5) — enum
  • created_at (Field6) — datetime
  • updated_at (Field7) — datetime
  • is_enable (Field8) — enum

User

  • user_id (Key) — long — Primary key — NOT NULL
  • email (Field) — varchar
  • password (Field2) — varchar
  • role (Field3) — varchar
  • state (Field6) — varchar
  • recent_login (Field7) — datetime
  • updated_at (Field5) — datetime
  • created_at (Field4) — datetime
  • is_enable (Field8) — enum

admin (Untitled8)

  • admin_id (Key) — long — Primary key — NOT NULL
  • identifier (Field) — varchar
  • password (Field2) — varchar
  • name (Field3) — varchar
  • created_at (Field4) — datetime
  • updated_at (Field5) — datetime
  • is_enable (Field6) — enum

alarm (Untitled26)

  • alarm_id (Key) — long — Primary key — NOT NULL
  • user_id (Key2) — long — Foreign key → User.user_id — NOT NULL
  • alarm_type (Field) — varchar
  • alarm_content (Field2) — varchar
  • alarm_type_id (Field3) — long
  • created_at (Field4) — datetime
  • is_enable (Field5) — enum

bookmark (Untitled5)

  • bookmark_id (Key2) — long — Primary key — NOT NULL
  • user_id (Key) — long — Foreign key → User.user_id — NOT NULL

business (Untitled2)

  • business_id (Key) — long — Primary key — NOT NULL
  • user_id (Key2) — long — Foreign key → User.user_id — NOT NULL
  • business_num (Field) — varchar
  • business_name (Field2) — varchar
  • business_address (Field3) — varchar
  • representative (Field4) — varchar
  • approval_date (Field5) — datetime
  • business_license (Field6) — varchar
  • business_phone (Field7) — varchar
  • business_fax (Field8) — varchar
  • request_date (Field9) — datetime
  • refusal_reason (Field10) — varchar

category (Untitled16)

  • category_id (Key) — long — Primary key — NOT NULL
  • category_title (Field) — varchar
  • category_image (Field2) — varchar
  • category_type (Field3) — varchar
  • category_seq (Field4) — int

coupon (Untitled6)

  • coupon_id (Key) — long — Primary key — NOT NULL
  • admin_id (Key2) — long — Foreign key → admin.admin_id — NOT NULL
  • state (Field) — varchar
  • coupon_start (Field2) — datetime
  • coupon_end (Field3) — datetime
  • coupon_type (Field4) — varchar
  • coupon_value (Field5) — int
  • coupon_code (Field6) — varchar
  • mode_payment (Field7) — enum
  • coupon_condition (Field8) — varchar
  • coupon_min (Field9) — int
  • coupon_max (Field10) — int

customer (Untitled)

  • customer_id (Key) — long — Primary key — NOT NULL
  • user_id (Key2) — long — Foreign key → User.user_id — NOT NULL
  • customer_name (Field) — varchar
  • customer_nickname (Field2) — varchar
  • customer_route (Field3) — varchar
  • customer_phone (Field4) — varchar
  • resident_registration_num (Field6) — varchar
  • customer_image (Field7) — varchar
  • customer_memo (Field5) — varchar
  • reservation_alarm (Field8) — enum
  • neighborhood_alarm (Field9) — enum
  • shop_alarm (Field10) — enum
  • marketing_alarm (Field11) — enum

ignore (Untitled13)

  • ignore_id (Key) — long — Primary key — NOT NULL
  • user_id (Key2) — long — Foreign key → User.user_id — NOT NULL
  • ignore_reason (Field) — varchar
  • created_at (Field2) — datetime

item (Untitled17)

  • item_id (Key) — long — Primary key — NOT NULL
  • user_id (Key2) — long — Foreign key → User.user_id — NOT NULL
  • category_id (Key3) — long — Foreign key → category.category_id — NOT NULL
  • latitude (Field) — decimal
  • longitude (Field2) — decimal
  • item_distance (Field3) — int
  • item_title (Field4) — varchar
  • item_content (Field5) — varchar
  • bargaining (Field6) — enum
  • min_use_date (Field7) — int
  • created_at (Field8) — datetime
  • updated_at (Field9) — datetime
  • is_enable (Field10) — enum

item_image (Untitled19)

  • item_image_id (Key) — long — Primary key — NOT NULL
  • item_id (Key2) — long — Foreign key → item.item_id — NOT NULL
  • item_image_seq (Field) — int
  • item_image_url (Field2) — varchar

item_like (Untitled38)

  • item_like_id (Key) — long — Primary key — NOT NULL
  • user_id (Key2) — long — Foreign key → User.user_id — NOT NULL
  • item_id (Key3) — long — Foreign key → item.item_id — NOT NULL
  • created_at (Field3)

item_price (Untitled18)

  • item_price_id (Key) — long — Primary key — NOT NULL
  • item_id (Key2) — long — Foreign key → item.item_id — NOT NULL
  • item_price_type (Field) — varchar
  • item_price_amount (Field2) — int

item_review (Untitled20)

  • item_review_id (Key) — long — Primary key — NOT NULL
  • user_id (Key2) — long — Foreign key → User.user_id — NOT NULL
  • reservation_id (Key3) — long — Foreign key → reservation.reservation_id — NOT NULL
  • item_review_content (Field2) — varchar
  • item_review_score (Field3) — int
  • item_review_type (Field4) — varchar

item_review_image (Untitled21)

  • item_review_image_id (Key) — long — Primary key — NOT NULL
  • item_review_id (Key2) — long — Foreign key → item_review.item_review_id — NOT NULL
  • reservation_id (Key3) — long — Foreign key → item_review.reservation_id — NOT NULL
  • item_review_image (Field) — varchar
  • item_review_seq (Field2) — int

manner (Untitled15)

  • manner_id (Key) — long — Primary key — NOT NULL
  • manner_level (Field) — int
  • manner_title (Field2) — varchar
  • manner_min_experience (Field3) — int
  • manner_max_experience (Field4) — int
  • manner_seq (Field5) — int
  • manner_image (Field6) — varchar

manner_check_list (Untitled23)

  • manner_check_list_id (Key) — long — Primary key — NOT NULL
  • manner_check_list_content (Field) — varchar
  • manner_check_list_type (Field2) — varchar

neighborhood (Untitled4)

  • neighborhood_id (Key) — long — Primary key — NOT NULL
  • user_id (Key2) — long — Foreign key → User.user_id — NOT NULL
  • neighborhood_name (Field) — varchar
  • neighborhood_distance (Field2) — int
  • neighborhood_certified (Field3) — enum

notice (Untitled9)

  • notice_id (Key) — long — Primary key — NOT NULL
  • admin_id (Key2) — long — Foreign key → admin.admin_id — NOT NULL
  • notice_title (Field) — varchar
  • notice_content (Field2) — varchar
  • view_count (Field4) — int
  • is_activation (Field8) — enum
  • created_at (Field5) — datetime
  • updated_at (Field6) — datetime
  • is_enable (Field7) — enum

payment (Untitled29)

  • payment_id (Key) — long — Primary key — NOT NULL
  • reservation_id (Key2) — long — Foreign key → reservation.reservation_id — NOT NULL
  • user_coupon_id (Key3) — long — Foreign key → user_coupon.user_coupon_id — NOT NULL
  • user_id (Key4) — long — Foreign key → User.user_id — NOT NULL
  • admin_id (Key22) — long — Foreign key → user_coupon.admin_id — NOT NULL
  • payment_state (Field) — varchar
  • is_calculate (Field2) — enum
  • payment_amount (Field3) — int
  • payment_price (Field4) — int
  • payment_discount (Field5) — int
  • payment_method (Field6) — varchar
  • payment_refund (Field7) — int
  • created_at (Field8) — datetime

post (Untitled31)

  • post_id (Key) — long — Primary key — NOT NULL
  • user_id (Key2) — long — Foreign key → User.user_id — NOT NULL
  • category (Field) — varchar
  • post_content (Field2) — varchar
  • neighborhood_name (Field3) — varchar
  • created_at (Field5) — datetime
  • updated_at (Field4) — datetime
  • is_enable (Field6) — enum

post_comment (Untitled34)

  • post_comment_id (Key) — long — Primary key — NOT NULL
  • user_id (Key2) — long — Foreign key → User.user_id — NOT NULL
  • post_id (Key3) — long — Foreign key → post.post_id — NOT NULL
  • post_comment_path (Field) — varchar
  • post_comment_content (Field2) — varchar
  • created_at (Field3) — datetime
  • updated_at (Field4) — datetime
  • is_enable (Field5) — enum

post_image (Untitled32)

  • post_image_id (Key) — long — Primary key — NOT NULL
  • post_id (Key2) — long — Foreign key → post.post_id — NOT NULL
  • post_image (Field) — varchar
  • post_seq (Field2) — int

post_like (Untitled33)

  • post_like_id (Key) — long — Primary key — NOT NULL
  • post_id (Key2) — long — Foreign key → post.post_id — NOT NULL
  • user_id (Key3) — long — Foreign key → User.user_id — NOT NULL
  • created_at (Field) — datetime

question (Untitled11)

  • question_id (Key) — long — Primary key — NOT NULL
  • admin_id (Key2) — long — Foreign key → admin.admin_id — NOT NULL
  • user_id (Key3) — long — Foreign key → User.user_id — NOT NULL
  • question_title (Field) — varchar
  • question_content (Field2) — varchar
  • question_answer (Field3) — varchar
  • state (Field4) — varchar
  • question_category (Field5) — varchar
  • question_created_at (Field6) — datetime
  • question_updated_at (Field7) — datetime
  • answer_created_at (Field8) — datetime
  • answer_updated_at (Field9) — datetime
  • is_public (Field10) — enum
  • is_activation (Field11) — enum
  • is_enable (Field12) — enum

question_image (Untitled12)

  • question_image_id (Key) — long — Primary key — NOT NULL
  • question_id (Key2) — long — Foreign key → question.question_id — NOT NULL
  • question_image (Field) — varchar
  • image_seq (Field2) — int

recent_item (Untitled25)

  • recent_item_id (Key) — long — Primary key — NOT NULL
  • user_id (Key2) — long — Foreign key → User.user_id — NOT NULL
  • item_id (Key3) — long — Foreign key → item.item_id — NOT NULL
  • created_at (Field) — datetime

recent_search (Untitled24)

  • recent_search_id (Key) — long — Primary key — NOT NULL
  • user_id (Key2) — long — Foreign key → User.user_id — NOT NULL
  • search_content (Field) — varchar
  • created_at (Field2) — datetime
  • is_enable (Field3) — enum

regular (Untitled36)

  • regular_id (Key) — long — Primary key — NOT NULL
  • user_id (Key2) — long — Foreign key → User.user_id — NOT NULL
  • regular_user_id (Field2) — long
  • created_at (Field) — datetime

reservation (Untitled27)

  • reservation_id (Key) — long — Primary key — NOT NULL
  • user_id (Key2) — long — Foreign key → User.user_id — NOT NULL
  • item_id (Key3) — long — Foreign key → item.item_id — NOT NULL
  • reservation_start (Field) — datetime
  • reservation_end (Field2) — datetime
  • reservation_state (Field3) — varchar
  • extension_count (Field4) — int
  • created_at (Field5) — datetime
  • updated_at (Field6) — datetime
  • is_enable (Field7) — enum

reservation_cancel (Untitled28)

  • reservation_cancel_id (Key) — long — Primary key — NOT NULL
  • reservation_id (Key2) — long — Foreign key → reservation.reservation_id — NOT NULL
  • cancel_reason (Field) — varchar
  • cancel_detail (Field2) — varchar
  • created_at (Field3) — datetime

review_manner_check_list (Untitled22)

  • review_manner_check_list_id (Key3) — long — Primary key — NOT NULL
  • item_review_id (Key) — long — Foreign key → item_review.item_review_id — NOT NULL
  • manner_check_list_id (Key2) — long — Foreign key → manner_check_list.manner_check_list_id — NOT NULL
  • reservation_id (Key32) — long — Foreign key → item_review.reservation_id — NOT NULL

secession

  • secession_id (Key) — long — Primary key — NOT NULL
  • user_id (Key2) — long — Foreign key → User.user_id — NOT NULL
  • secession_reason (Field) — varchar
  • created_at (Field2) — datetime

tax_bill (Untitled30)

  • tax_bill_id (Key) — long — Primary key — NOT NULL
  • reservation_id (Key2) — long — Foreign key → reservation.reservation_id — NOT NULL
  • business_name (Field) — varchar
  • business_num (Field2) — varchar
  • representative (Field3) — varchar
  • business_type (Field4) — varchar
  • business_address (Field5) — varchar
  • postal_code (Field6) — int
  • detail_address (Field7) — varchar
  • email (Field8) — varchar
  • manager (Field9) — varchar
  • manager_phone (Field10) — varchar
  • created_at (Field11) — datetime

user_account (Untitled3)

  • user_account_id (Key) — long — Primary key — NOT NULL
  • user_id (Key2) — long — Foreign key → User.user_id — NOT NULL
  • account_num (Field) — varchar
  • bank (Field2) — varchar
  • account_holder (Field3) — varchar
  • created_at (Field4) — datetime
  • updated_at (Field5) — datetime

user_coupon (Untitled7)

  • user_coupon_id (Key) — long — Primary key — NOT NULL
  • user_id (Key2) — long — Foreign key → User.user_id — NOT NULL
  • coupon_id (Key3) — long — Foreign key → coupon.coupon_id — NOT NULL
  • admin_id (Key22) — long — Foreign key → coupon.admin_id — NOT NULL
  • user_coupon_start (Field) — datetime
  • user_coupon_end (Field2) — datetime
  • state (Field3) — varchar
  • created_at (Field4) — datetime

user_manner (Untitled14)

  • user_manner_id (Key) — long — Primary key — NOT NULL
  • user_id (Key2) — long — Foreign key → User.user_id — NOT NULL
  • manner_id (Key3) — long — Foreign key → manner.manner_id — NOT NULL
  • experience (Field2) — int

user_shop(blog) (Untitled35)

  • shop_id (Key) — long — Primary key — NOT NULL
  • user_id (Key2) — long — Foreign key → User.user_id — NOT NULL
  • background_image (Field) — varchar
  • template (Field2)
  • shop_title (Field3) — varchar
  • shop_content (Field4) — varchar

user_shop_comment (Untitled37)

  • shop_comment_id (Key) — long — Primary key — NOT NULL
  • shop_id (Key2) — long — Foreign key → user_shop(blog).shop_id — NOT NULL
  • user_id (Key3) — long — Foreign key → User.user_id — NOT NULL
  • shop_comment_content (Field) — varchar
  • created_at (Field2) — datetime
  • updated_at (Field3) — datetime
  • is_enable (Field4) — enum