ddd
Tables (50)
Untitled2
- refund_id — varchar(100) — NOT NULL
- refund_date — date — NOT NULL
- refund_status — varchar(100) — NOT NULL
- refund_amount — int — NOT NULL
- refund_bank — int — NOT NULL
- return_id — varchar(100) — NOT NULL
- payment_id — int — NOT NULL
cart
- cart_id — int — NOT NULL
- product_id — int — NOT NULL
- user_id — int — NOT NULL
- cart_item_count — int — NOT NULL
- cart_expect_price — int — NOT NULL
channel
- channel_no — int — NOT NULL
- user_id — int — NOT NULL
- channel_title — varchar(255) — NOT NULL
- channel_description — varchar(4000) — NOT NULL
- channel_create_date — datetime — NOT NULL
- channel_update_date — datetime — NOT NULL
- channel_delete_date — datetime — NOT NULL
- channel_delete — boolean — NOT NULL
channel_participant
- channel_no — int — NOT NULL
- user_id — int — NOT NULL
channel_post
- post_no — int — NOT NULL
- channel_no — int — NOT NULL
- user_id — int — NOT NULL
- post_title — varchar(255) — NOT NULL
- post_content — text — NOT NULL
- post_view_count — int — NOT NULL
- post_create_date — datetime — NOT NULL
- post_update_date — datetime — NOT NULL
- post_delete_date — datetime — NOT NULL
- post_delete — boolean — NOT NULL
channel_post_complaint
- complaint_id — int — NOT NULL
- post_no — int — NOT NULL
- user_id — int — NOT NULL
- complaint_category_no — int — NOT NULL
- complaint_create_date — datetime — NOT NULL
channel_post_image
- image_no — int — NOT NULL
- post_no — int — NOT NULL
- image_name — varchar(255) — NOT NULL
channel_post_like
- post_no — int — NOT NULL
- user_id — int — NOT NULL
channel_post_reply
- post_reply_no — int — NOT NULL
- post_no — int — NOT NULL
- user_id — int — NOT NULL
- post_reply_content — varchar(255) — NOT NULL
- post_reply_create_date — datetime — NOT NULL
- post_reply_update_date — datetime — NOT NULL
- post_reply_delete_date — datetime — NOT NULL
- post_reply_delete — boolean — NOT NULL
- parent_reply_no — int
channel_post_reply_complaint
- complaint_id — int — NOT NULL
- reply_no — int — NOT NULL
- user_id — int — NOT NULL
- complaint_category_no — int — NOT NULL
- complaint_create_date — datetime — NOT NULL
channel_post_reply_like
- user_id — int — NOT NULL
- reply_no — int — NOT NULL
community
- community_no — int — NOT NULL
- category_no — int — NOT NULL
- user_id — int — NOT NULL
- community_title — varchar(255) — NOT NULL
- community_content — text — NOT NULL
- community_view_count — int — NOT NULL
- community_create_date — datetime — NOT NULL
- community_update_date — datetime — NOT NULL
- community_delete_date — datetime — NOT NULL
- community_delete — boolean — NOT NULL
community_category
- category_no — int — NOT NULL
- category_name — varchar(255) — NOT NULL
community_complaint
- community_complaint_id — int — NOT NULL
- user_id — int — NOT NULL
- community_no — int — NOT NULL
- complaint_category_no — int — NOT NULL
- complaint_create_date — datetime — NOT NULL
- Field — VARCHAR(255)
community_image
- image_no — int — NOT NULL
- community_no — int — NOT NULL
- image_name — varchar(255) — NOT NULL
community_like
- community_no — int — NOT NULL
- user_id — int — NOT NULL
community_reply
- community_reply_no — int — NOT NULL
- community_no — int — NOT NULL
- user_id — int — NOT NULL
- community_reply_content — varchar(255) — NOT NULL
- community_reply_create_date — datetime — NOT NULL
- community_reply_update_date — datetime — NOT NULL
- community_reply_delete_date — datetime — NOT NULL
- community_reply_delete — boolean — NOT NULL
- parent_reply_no — int
community_reply_complaint
- complaint_id — int — NOT NULL
- user_id — int — NOT NULL
- community_reply_no — int — NOT NULL
- complaint_category_no — int — NOT NULL
- complaint_create_date — datetime — NOT NULL
- Field — VARCHAR(255)
community_reply_like
- reply_no — int — NOT NULL
- user_id — int — NOT NULL
community_scrap
- community_no — int — NOT NULL
- user_id — int — NOT NULL
complaint_category
- complaint_category_no — int — NOT NULL
- complaint_category_content — varchar(255) — NOT NULL
delivery
- delivery_id — int — NOT NULL
- user_id — int — NOT NULL
- delivery_name — varchar(255) — NOT NULL
- delivery_recipient — varchar(255) — NOT NULL
- delivery_phone — varchar(50) — NOT NULL
- delivery_address — varchar(255) — NOT NULL
- delivery_zipcode — varchar(6) — NOT NULL
- delivery_memo — varchar(255)
exchange
- exchange_id — varchar(100) — NOT NULL
- exchange_date — date — NOT NULL
- exchange_stauts — varchar(100) — NOT NULL
- order_id — int — NOT NULL
- exchange_description — varchar(255) — NOT NULL
faq
- faq_id — int — NOT NULL
- faq_title — varchar(255) — NOT NULL
- faq_content — varchar(4000) — NOT NULL
- faq_category — varchar(255) — NOT NULL
- faq_create_date — datetime — NOT NULL
- faq_update_date — datetime — NOT NULL
- faq_delete — boolean — NOT NULL
follow
- user_follower — int — NOT NULL
- user_owner — int — NOT NULL
notice
- notice_id — int — NOT NULL
- notice_title — varchar(255) — NOT NULL
- notice_content — varchar(4000) — NOT NULL
- notice_create_date — datetime — NOT NULL
- notice_update_date — datetime — NOT NULL
- notice_delete — boolean — NOT NULL
notification
- notification_id — int — NOT NULL
- user_id — int — NOT NULL
- action_user_id — int
- notification_category — varchar(255)
- notification_content — varchar(50) — NOT NULL
- notification_date — datetime — NOT NULL
- notification_read — boolean — NOT NULL
- notification_read_date — datetime
- is_subscribed — boolean — NOT NULL
order
- order_id — int — NOT NULL
- user_id — int — NOT NULL
- order_date — datetime — NOT NULL
- order_price — int — NOT NULL
- order_status — varchar(255) — NOT NULL
- order_payment_status — varchar(255) — NOT NULL
- order_update_date — datetime — NOT NULL
- delivery_id — int — NOT NULL
order_cancel
- order_cancel_id — int — NOT NULL
- order_id — int — NOT NULL
- order_cancel_date — datetime — NOT NULL
- order_cancel_withdrawal_date — datetime
- order_cancel_description — varchar(255) — NOT NULL
order_detail
- order_detail_id — int — NOT NULL
- order_id — int — NOT NULL
- product_id — int — NOT NULL
- product_count — int — NOT NULL
- product_price — int — NOT NULL
payment
- payment_id — int — NOT NULL
- order_id — int — NOT NULL
- payment_price — int — NOT NULL
- payment_date — datetime — NOT NULL
- payment_method — varchar(255) — NOT NULL
- payment_use_point — int — NOT NULL
- payment_delivery_price — int — NOT NULL
point_history
- point_id — int — NOT NULL
- point_amout — int — NOT NULL
- point_type — varchar(255) — NOT NULL
- point_action — varchar(255) — NOT NULL
- point_description — varchar(255) — NOT NULL
- point_date — datetime — NOT NULL
- point_expire_date — datetime — NOT NULL
- user_id — int — NOT NULL
product
- product_id — int — NOT NULL
- product_name — varchar(255) — NOT NULL
- product_content — varchar(255) — NOT NULL
- product_price — int — NOT NULL
- product_discount — int
- product_amount — int — NOT NULL
- product_status — varchar(255) — NOT NULL
- product_create_date — date — NOT NULL
- product_update_date — date — NOT NULL
- tag_id — int — NOT NULL
- category_id — int — NOT NULL
- Field3 — varchar(255)
- Field4 — varchar(255)
- Field5 — varchar(1) — NOT NULL
product_category
- category_id — int — NOT NULL
- category_name — varchar(255) — NOT NULL
- parents_category — int
product_detail
- product_detail_id — int — NOT NULL
- product_detail_option — varchar(255) — NOT NULL
- product_detail_option_value — varchar(255) — NOT NULL
- product_detail_stock — int — NOT NULL
- product_id — int — NOT NULL
- category_id — int — NOT NULL
product_review
- product_review_id — int — NOT NULL
- user_id — int — NOT NULL
- order_detail_id — int — NOT NULL
- product_review_content — varchar(255) — NOT NULL
- product_review_creat_date — date — NOT NULL
- product_review_update_date — date — NOT NULL
- product_rating — int — NOT NULL
product_review_vote
- product_review_vote_id — int — NOT NULL
- product_review_id — int — NOT NULL
- user_id — int — NOT NULL
product_tag
- tag_id — int — NOT NULL
- tag_name — varchar(255) — NOT NULL
qna
- qna_id — int — NOT NULL
- qna_category_id — int — NOT NULL
- qna_title — varchar(255) — NOT NULL
- qna_content — varchar(4000) — NOT NULL
- user_id — int — NOT NULL
- qna_create_date — datetime — NOT NULL
- qna_delete — boolean — NOT NULL
- qna_answer — varchar(4000)
- qna_answer_status — boolean — NOT NULL
return
- return_id — varchar(100) — NOT NULL
- order_number — varchar(100) — NOT NULL
- return_date — date — NOT NULL
- return_status — varchar(100) — NOT NULL
- change_id — varchar(100) — NOT NULL
- order_id — int — NOT NULL
- exchange_description — varchar(255) — NOT NULL
scrap
- scrap_id — int — NOT NULL
- scrap_create_date — datetime — NOT NULL
- user_id — int — NOT NULL
- product_id — int — NOT NULL
- community_no — int — NOT NULL
scrap_folder
- scrap_foler_id — int — NOT NULL
- scrap_foler_name — varchar(255) — NOT NULL
- scrap_foler_description — varchar(255) — NOT NULL
- user_id — int — NOT NULL
scrap_folder_item
- scrap_folder_item_id — int — NOT NULL
- scrap_foler_id — int — NOT NULL
- scrap_id — int — NOT NULL
social_login
- social_login_id — int — NOT NULL
- provider — varchar(255)
- social_id — varchar(255)
- user_id — int — NOT NULL
term
- term_id — int — NOT NULL
- term_title — varchar(255) — NOT NULL
- term_content — varchar(255) — NOT NULL
- term_create_date — datetime — NOT NULL
- is_required — boolean — NOT NULL
term_agreed
- user_id — int — NOT NULL
- term_id — int — NOT NULL
- agree_date — datetime — NOT NULL
user
- user_id — int — NOT NULL
- user_email — varchar(255) — NOT NULL
- user_password — varchar(60) — NOT NULL
- user_nickname — varchar(80) — NOT NULL
- user_profile_photo — varchar(255) — NOT NULL
- user_tel — varchar(20) — NOT NULL
- user_birth_date — datetime — NOT NULL
- user_introduction — varchar(255) — NOT NULL
- user_sns — varchar(255) — NOT NULL
- user_create_date — datetime — NOT NULL
- user_update_date — datetime — NOT NULL
- user_role — varchar(255) — NOT NULL
- user_recommend_code — varchar(255) — NOT NULL
- is — _social` — NOT NULL
- is_active — boolean — NOT NULL
- user_grade_id — int — NOT NULL
- user_point — int — NOT NULL
- user_address — varchar(255) — NOT NULL
- user_danger_count — int — NOT NULL
user_grade
- user_grade_id — int — NOT NULL
- user_grade_name — varchar(255) — NOT NULL
user_hide
- user_hide_id — VARCHAR(255) — NOT NULL
- user_hide_create_date — VARCHAR(255)
- user_id — int — NOT NULL
- hide_user_id — int — NOT NULL
visit
- visit_date — datetime — NOT NULL
- visit_count — int — NOT NULL