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