MOC ERD
Tables (31)
tb_chat_message
- chat_message_id — NUMBER — Primary key — NOT NULL
- chat_room_id — NUMBER — NOT NULL — INDEX
- sender_id — VARCHAR2(255) — NOT NULL
- message_content — VARCHAR2(1000) — NOT NULL
- message_type — VARCHAR2(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL — INDEX
- created_by — VARCHAR2(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR2(255)
tb_chat_room
- chat_room_id — NUMBER — Primary key — NOT NULL
- post_id — NUMBER — NOT NULL — UNIQUE INDEX
- post_type — VARCHAR2(20) — NOT NULL — INDEX
- owner_id — VARCHAR2(255) — NOT NULL — UNIQUE INDEX
- participant_id — VARCHAR2(255) — NOT NULL — UNIQUE INDEX
- room_status — VARCHAR2(20) — NOT NULL
- is_accepted — CHAR(1) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR2(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR2(255)
tb_chat_room_hidden
- hidden_id — NUMBER — Primary key — NOT NULL
- chat_room_id — NUMBER — NOT NULL — UNIQUE
- user_id — VARCHAR2(255) — NOT NULL — UNIQUE INDEX
- hidden_at — TIMESTAMP — NOT NULL
tb_chat_room_read
- chat_room_read_id — NUMBER — Primary key — NOT NULL
- chat_room_id — NUMBER — NOT NULL — UNIQUE
- user_id — VARCHAR2(255) — NOT NULL — UNIQUE
- last_read_at — TIMESTAMP — NOT NULL
tb_comment_notification
- comment_notification_id — NUMBER — Primary key — NOT NULL
- post_id — NUMBER — NOT NULL — INDEX
- post_type — VARCHAR2(20) — NOT NULL
- post_author_id — VARCHAR2(255) — NOT NULL
- commenter_id — VARCHAR2(255) — NOT NULL
- comment_id — NUMBER — NOT NULL — INDEX
- is_read — CHAR(1) — NOT NULL
- created_at — TIMESTAMP
- created_by — VARCHAR2(255)
tb_common
- code — VARCHAR2(20) — Primary key — NOT NULL — UNIQUE
- master_code — VARCHAR2(20) — NOT NULL — UNIQUE
- code_name — VARCHAR2(50) — NOT NULL
tb_conv_comb
- conv_comb_id — NUMBER — Primary key — NOT NULL
- user_id — VARCHAR2(255) — NOT NULL — INDEX
- conv_comb_title — VARCHAR2(255) — NOT NULL
- conv_comb_main_product — VARCHAR2(255) — NOT NULL
- conv_comb_category — VARCHAR2(20) — NOT NULL — INDEX
- conv_comb_tip — CLOB — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR2(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR2(255)
tb_conv_comb_comment
- conv_comb_comment_id — NUMBER — Primary key — NOT NULL
- conv_comb_id — NUMBER — NOT NULL — INDEX
- user_id — VARCHAR2(255) — NOT NULL
- conv_comb_comment_content — VARCHAR2(500) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR2(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR2(255)
tb_conv_comb_image
- conv_comb_image_id — NUMBER — Primary key — NOT NULL
- conv_comb_id — NUMBER — NOT NULL — INDEX
- conv_comb_image_url — VARCHAR2(500) — NOT NULL
- conv_comb_image_path — VARCHAR2(500) — NOT NULL
- conv_comb_image_index — NUMBER — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR2(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR2(255)
tb_conv_comb_product
- conv_comb_product_id — NUMBER — Primary key — NOT NULL
- conv_comb_id — NUMBER — NOT NULL — INDEX
- conv_comb_product_content — VARCHAR2(150) — NOT NULL
- conv_comb_product_index — NUMBER — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR2(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR2(255)
tb_conv_comb_recipe
- conv_comb_recipe_id — NUMBER — Primary key — NOT NULL
- conv_comb_id — NUMBER — NOT NULL — INDEX
- conv_comb_recipe_content — VARCHAR2(150) — NOT NULL
- conv_comb_recipe_index — NUMBER — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR2(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR2(255)
tb_conv_review
- conv_review_id — NUMBER — Primary key — NOT NULL
- user_id — VARCHAR2(255) — NOT NULL — INDEX
- conv_review_title — VARCHAR2(255) — NOT NULL
- conv_reivew_content — CLOB — NOT NULL
- conv_review_price — NUMBER
- conv_review_store — VARCHAR2(20) — NOT NULL — INDEX
- conv_review_category — VARCHAR2(20) — NOT NULL — INDEX
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR2(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR2(255)
tb_conv_review_comment
- conv_review_comment_id — NUMBER — Primary key — NOT NULL
- conv_review_id — NUMBER — NOT NULL — UNIQUE
- user_id — VARCHAR2(255) — NOT NULL
- conv_review_comment_content — VARCHAR2(500) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR2(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR2(255)
tb_conv_review_image
- conv_review_image_id — NUMBER — Primary key — NOT NULL
- conv_review_id — NUMBER — NOT NULL — UNIQUE
- conv_review_image_url — VARCHAR2(500) — NOT NULL
- conv_review_image_path — VARCHAR2(500) — NOT NULL
- conv_review_image_index — NUMBER — NOT NULL — UNIQUE
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR2(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR2(255)
tb_freeboard
- freeboard_id — NUMBER — Primary key — NOT NULL
- user_id — VARCHAR2(255) — NOT NULL — INDEX
- freeboard_title — VARCHAR2(255) — NOT NULL
- freeboard_content — CLOB — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR2(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR2(255)
tb_freeboard_comment
- freeboard_comment_id — NUMBER — Primary key — NOT NULL
- freeboard_id — NUMBER — NOT NULL — INDEX
- user_id — VARCHAR2(255) — NOT NULL — INDEX
- freeboard_comment_content — VARCHAR2(500) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR2(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR2(255)
tb_master_common
- master_code — VARCHAR2(20) — Primary key — NOT NULL — UNIQUE
- master_name — VARCHAR2(50) — NOT NULL — UNIQUE INDEX
tb_notice
- notice_id — NUMBER — Primary key — NOT NULL
- report_reason — VARCHAR2(255) — NOT NULL
- notice_title — VARCHAR2(255) — NOT NULL
- notice_content — VARCHAR2(1000) — NOT NULL
- created_at — TIMESTAMP — NOT NULL — INDEX
- created_by — VARCHAR2(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR2(255)
tb_recipe
- recipe_id — NUMBER — Primary key — NOT NULL
- user_id — VARCHAR2(255) — NOT NULL — INDEX
- recipe_title — VARCHAR2(255) — NOT NULL
- recipe_main_ingredient — VARCHAR2(255) — NOT NULL
- recipe_content — CLOB — NOT NULL
- created_at — TIMESTAMP — NOT NULL — INDEX
- created_by — VARCHAR2(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR2(255)
tb_recipe_comment
- recipe_comment_id — NUMBER — Primary key — NOT NULL
- recipe_id — NUMBER — NOT NULL — INDEX
- user_id — VARCHAR2(255) — NOT NULL — INDEX
- recipe_comment_content — VARCHAR2(500) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR2(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR2(255)
tb_recipe_detail_ingredient
- recipe_detail_ingredient_id — NUMBER — Primary key — NOT NULL
- recipe_id — NUMBER — NOT NULL
- recipe_detail_ingredient_content — VARCHAR2(255) — NOT NULL
- recipe_detail_ingredient_index — NUMBER — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR2(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR2(255)
tb_recipe_image
- recipe_image_id — NUMBER — Primary key — NOT NULL
- recipe_id — NUMBER — NOT NULL — UNIQUE INDEX
- recipe_image_url — VARCHAR2(500) — NOT NULL
- recipe_image_path — NUMBER — NOT NULL
- recipe_image_index — VARCHAR(255)
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR2(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR2(255)
tb_recipe_order
- recipe_order_id — NUMBER — Primary key — NOT NULL
- recipe_id — NUMBER — NOT NULL — INDEX
- recipe_order_content — VARCHAR2(255) — NOT NULL
- recipe_order_index — NUMBER — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR2(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR2(255)
tb_region
- city_code — VARCHAR2(50) — Primary key — NOT NULL — UNIQUE
- master_code — VARCHAR2(20) — NOT NULL — UNIQUE
- region_code — VARCHAR2(50) — NOT NULL
- region_name — VARCHAR2(50) — NOT NULL
- city_name — VARCHAR2(50) — NOT NULL
tb_report
- report_id — NUMBER — Primary key — NOT NULL
- user_id — VARCHAR2(255) — NOT NULL — INDEX
- report_type — VARCHAR2(20) — NOT NULL — INDEX
- board_type — VARCHAR2(50) — NOT NULL — INDEX
- target_id — NUMBER — NOT NULL — INDEX
- report_content — VARCHAR2(500) — NOT NULL
- report_status — VARCHAR2(50) — INDEX
- processed_by — VARCHAR2(255)
- processed_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR2(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR2(255)
tb_saved_posts
- saved_post_id — NUMBER — Primary key — NOT NULL
- user_id — VARCHAR2(255) — NOT NULL — UNIQUE INDEX
- board_type — VARCHAR2(50) — NOT NULL — UNIQUE INDEX
- post_id — NUMBER — NOT NULL — UNIQUE INDEX
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR2(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR2(255)
tb_sharetool
- sharetool_id — NUMBER — Primary key — NOT NULL
- user_id — VARCHAR2(255) — NOT NULL
- sharetool_title — VARCHAR2(50) — NOT NULL
- sharetool_product — VARCHAR2(255) — NOT NULL
- sharetool_content — CLOB — NOT NULL
- sharetool_status — VARCHAR2(50) — NOT NULL — INDEX
- sharetool_province — VARCHAR2(50) — NOT NULL — INDEX
- sharetool_city — VARCHAR2(50) — NOT NULL — INDEX
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR2(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR2(255)
tb_sharetool_image
- sharetool_image_id — NUMBER — Primary key — NOT NULL
- sharetool_id — NUMBER — NOT NULL — UNIQUE INDEX
- sharetool_image_url — VARCHAR2(500) — NOT NULL
- sharetool_image_path — VARCHAR2(500) — NOT NULL
- sharetool_image_index — NUMBER — NOT NULL — UNIQUE
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR2(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR2(255)
tb_user
- user_id — VARCHAR2(50) — Primary key — NOT NULL
- user_email — VARCHAR2(100) — NOT NULL — UNIQE INDEX
- user_nickname — VARCHAR2(255) — NOT NULL — UNIQE INDEX
- user_name — VARCHAR2(50) — NOT NULL
- user_pwd — VARCHAR2(20) — NOT NULL
- user_status — varchar2(20) — NOT NULL
- user_isadmin — VARCHAR(1) — NOT NULL
- withdrawn_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR2(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR2(255)
tb_user_image
- user_image_id — NUMBER — Primary key — NOT NULL
- user_id — VARCHAR2(255) — NOT NULL
- user_image_url — VARCHAR2(500) — NOT NULL
- user_image_path — VARCHAR2(500) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR2(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR2(255)
tb_withshopping
- withshopping_id — NUMBER — Primary key — NOT NULL
- user_id — VARCHAR2(255) — NOT NULL
- withshopping_title — VARCHAR2(255) — NOT NULL
- withshopping_content — CLOB — NOT NULL
- withshopping_status — VARCHAR2(50) — NOT NULL — INDEX
- withshopping_si — VARCHAR2(50) — NOT NULL — INDEX
- withshopping_gu — VARCHAR2(50) — NOT NULL — INDEX
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR2(255) — NOT NULL
- updated_at — TIMESTAMP
- updated_by — VARCHAR2(255)