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