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)