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