db

Tables (11)

tb_chat (채팅)

  • chat_idx (Key) — int — Primary key — NOT NULL
  • chat_deleteYn (Field2) — varchar
  • chat_title (Field) — varchar
  • chat_create_date (Field3) — timestamp
  • chat_sender_idx (Field4) — int
  • chat_recipient_idx (Field5) — int
  • Field6

tb_code (공통코드(로그인sns,컨텐츠플랫폼,컨텐츠장르,컨텐츠태그,컨텐츠제작진분류))

  • code_idx (Key) — int — Primary key — NOT NULL
  • code_subject (Field) — varchar
  • code_catecode (Field2) — varchar
  • Field3

tb_contents (컨텐츠)

  • contents_idx (Key) — int — Primary key — NOT NULL
  • contents_deleteYn (Field3) — varchar
  • contents_catecode (Field) — varchar
  • contents_title (Field2) — varchar
  • contents_views (Field4) — int
  • contents_likes (Field5) — int
  • Field8

tb_contents_image (컨텐츠이미지)

  • image_idx (Key) — int — Primary key — NOT NULL
  • image_origin_name (Field) — varchar
  • image_saved_name (Field2) — varchar
  • image_path (Field3) — varchar
  • image_size (Field4) — int
  • Field5

tb_contents_maker (컨텐츠제작진)

  • contents_maker_idx (Key) — int — Primary key — NOT NULL
  • contents_idx (Field) — int
  • code_idx (Field2) — int
  • contents_maker_name (Field3) — varchar
  • Field4

tb_contents_review (컨텐츠리뷰)

  • contents_review_idx (Key) — int — Primary key — NOT NULL
  • contents_review_deleteYn (Field4) — varchar
  • user_idx (Field2) — int
  • contents_review_content (Field) — varchar
  • contents_review_create_date (Field3) — timestamp

tb_contents_tag (컨텐츠태그)

  • contensts_tag_idx (Key) — int — Primary key — NOT NULL
  • contents_idx (Field) — int
  • code_idx (Field2) — int
  • Field3

tb_platform_logo (컨텐츠플랫폼로고이미지)

  • platform_logo_idx (Key) — int — Primary key — NOT NULL
  • code_idx (Field5) — int
  • platform_logo_origin_filename (Field) — varchar
  • platform_logo_filename (Field2) — varchar
  • platform_logo_path (Field3) — varchar
  • platform_logo_size (Field4) — int
  • Field6

tb_post (게시글)

  • post_idx (Key) — int — Primary key — NOT NULL
  • post_deleteYn (Field2) — varchar
  • user_idx (Field3) — int
  • post_create_date (Field) — timestamp
  • post_subject (Field4) — varchar
  • post_content (Field5) — varchar
  • Field6

tb_post_comment (게시글댓글)

  • comment_idx (Key) — int — Primary key — NOT NULL
  • post_comment_deleteYn (Field8) — varchar
  • user_idx (Field2) — int
  • post_comment_content (Field) — varchar
  • post_comment_create_date (Field3) — timestamp
  • post_comment_deleteYn (Field4) — varchar
  • post_comment_groupNo (Field5) — int
  • post_comment_groupOrd (Field6) — int
  • post_comment_groupDepth (Field7) — int
  • Field9

tb_user (유저)

  • user_idx (Key) — int — Primary key — NOT NULL
  • user_deleteYn (Field8) — varchar
  • code_idx (Field10) — int
  • user_name (Field3) — varchar
  • user_id (Field) — varchar
  • user_password (Field2) — varchar
  • user_grade (Field11) — varchar
  • user_phone (Field4) — varchar
  • user_email (Field6) — varchar
  • user_create_date (Field5) — timestamp
  • user_login_date (Field7) — timestamp
  • user_ip (Field9) — varchar
  • Field12