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