asdfasdf
Tables (10)
admin_info
- admin_id — varchar2(20)
- admin_pwd — varchar2(20) — NOT NULL
board
- board_seq — number
- board_code — varchar2(10) — NOT NULL
- board_user_id — varchar2(20)
- board_writer — varchar2(50) — NOT NULL
- board_title — varchar2(1000) — NOT NULL
- board_content — varchar2(3000)
- board_img — varchar2(1000)
- board_sysdate — date — NOT NULL
- board_like — number — NOT NULL
- board_unlike — number — NOT NULL
- board_view — number — NOT NULL
board_comments
- board_comments_parent_code — varchar2(10)
- board_comment_parent_seq — number
- board_comment_user_id — references
- board_comment_writer — varchar2(50) — NOT NULL
- board_comment_content — varchar2(3000) — NOT NULL
- board_comment_sysdate — date — NOT NULL
corp_info
- corp_name — varchar2(100)
- corp_logo_img — varchar2(1000)
- corp_website — varchar2(1000)
- corp_intro — varchar2(3000)
img
- img_name — varchar2(500) — NOT NULL
- img_path — varchar2(1000) — NOT NULL
job_post
- post_seq — number
- post_corp_name — varchar2(100)
- post_name — varchar2(500) — NOT NULL
- post_url — varchar2(3000) — NOT NULL
- post_content — varchar2(3000)
- post_period_start — date — NOT NULL
- post_period_end — date
- post_like — number — NOT NULL
- post_unlike — number — NOT NULL
- post_view — number — NOT NULL
- post_classi_code — varchar2(10) — NOT NULL
member_Info
- member_id — varchar2(20)
- member_pwd — varchar2(20) — NOT NULL
- member_name — varchar2(20) — NOT NULL
- member_nickname — varchar2(50) — NOT NULL
- member_phone — varchar2(50) — NOT NULL
- member_birthdate — date — NOT NULL
- member_email — varchar2(50) — NOT NULL
- member_gender — varchar2(10) — NOT NULL
- member_status_msg — varchar2(300)
- member_joindate — date — NOT NULL
- member_address — varchar2(300) — NOT NULL
- member_pref_code — varchar2(10)
my_scheduler
- sche_user_id — varchar2(20)
- sche_date — date — NOT NULL
- sche_content — varchar2(3000)
post_comments
- post_comment_parent_seq — number
- post_comment_user_id — varchar2(20)
- post_comment_writer — varchar2(50)
- post_comment_content — varchar2(3000) — NOT NULL
- post_comment_sysdate — date — NOT NULL
post_scrap
- scrap_user_id — varchar2(20)
- scrap_parent_seq — number
- scrap_post_name — varchar2(500)
- scrap_post_link — varchar2(1000)
- scrap_post_period_start — date
- scrap_post_period_end — date