kmerz

Tables (10)

tbl_admin

  • admin_id — varchar(30)
  • admin_pw — varchar(50) — NOT NULL
  • admin_name — varchar(30) — NOT NULL
  • admin_pic — varchar(1)

tbl_adminmessage

  • message_no — double
  • admin_id — varchar(30) — NOT NULL
  • message_title — varchar(100) — NOT NULL
  • message_content — varchar(300)
  • message_level — number(1)

tbl_category

  • category_no — double
  • community_id — varchar(30)
  • category_name — varchar2(50)
  • category_description — varchar2(300)
  • category_status — varchar2(15)

tbl_comment

  • comment_no — double
  • post_no — double
  • user_name — varchar2(50)
  • comment_content — varchar2(200) — NOT NULL
  • comment_reply_count — number
  • comment_regist_date — timestamp

tbl_community

  • community_id — varchar(30)
  • user_id — varchar(50)
  • community_name — varchar2(50) — NOT NULL
  • community_topic — varchar2(50) — NOT NULL
  • community_description — varchar2(300)
  • community_status — varchar2(15) — NOT NULL

tbl_media

  • media_no — double
  • media_id — varchar2(100)
  • media_path — varchar2(100)
  • upload_time — timestamp
  • delete_time — timestamp

tbl_member

  • user_no — number
  • user_id — number — NOT NULL
  • user_pw — varchar(50) — NOT NULL
  • user_name — varchar(50) — NOT NULL
  • user_currentlogin — datetime(6)
  • user_status — varchar(15)

tbl_member_log

  • user_log_code — varchar(20)
  • user_id — varchar(50)
  • user_request_ip — varchar2(20)
  • user_request_content — varchar2(200)
  • user_log_time — timestamp

tbl_posts

  • post_no — double
  • user_name — varchar(50)
  • community_id — varchar2(50)
  • category_no — number
  • post_title — varchar2(100)
  • post_content_file — varchar2(500)
  • post_readcount — number
  • post_recommand — number
  • post_lastupdate — timestamp
  • post_status — varchar2(15)

tbl_reply

  • reply_no — double
  • comment_no — double
  • user_name — varchar(50)
  • reply_content — varchar2(200) — NOT NULL
  • reply_regist_date — timestamp