jardin

5팀 jardin

테이블 (13)

EVENT (진행/종료)

  • event (event_id) — number — 기본 키 — NOT NULL
  • event (admin) — varchar2(20) — 외래 키 → 관리자.admin — NOT NULL
  • event (event_title) — varchar2(200)
  • event (event_content) — varchar2(2000)
  • event (event_startDate) — date
  • event (event_endDate) — date
  • event (event_hit) — number
  • event (event_image1) — varchar2(200)
  • event (event_image2) — varchar2(200)

EVENT (이벤트 댓글)

  • event_reply (eventReply_id) — number — 외래 키 → EVENT.event — NOT NULL
  • event_reply (eventReply_user) — varchar2(40) — 외래 키 → MEMBERSHIP.d_member — NOT NULL
  • event_reply (admin) — varchar2(20) — 외래 키 → 관리자.admin — NOT NULL
  • event_reply (eventReply_pw) — varchar2(40)
  • event_reply (eventReply_content) — varchar2(2000)
  • event_reply (eventReply_date) — date
  • event_reply (eventReply_group) — number
  • event_reply (eventReply_step) — number
  • event_reply (eventReply_indent) — number

EVENT (당첨자 발표)

  • prize (prize_id) — number — 기본 키 — NOT NULL
  • prize (admin) — varchar2(20) — 외래 키 → 관리자.admin — NOT NULL
  • prize (prize_title) — varchar2(200)
  • prize (prize_content) — varchar2(2000)
  • prize (prize_list) — varchar2(200)
  • prize (prize_date) — date
  • prize (prize_hit) — number

MEMBERSHIP (회원가입)

  • d_member (d_id) — varchar2(20) — 기본 키 — NOT NULL
  • d_member (d_name) — varchar2(20)
  • d_member (d_pw) — varchar2(20)
  • d_member (d_email1) — varchar2(30)
  • d_member (d_email2) — varchar2(30)
  • d_member (d_email_check) — char(1)
  • d_member (d_zipcode) — varchar2(50)
  • d_member (d_address) — varchar2(50)
  • d_member (d_phone1) — varchar2(30)
  • d_member (d_phone2) — varchar2(30)
  • d_member (d_phone3) — varchar2(30)
  • d_member (d_sms) — char(3)
  • d_member (d_tel1) — varchar2(30)
  • d_member (d_tel2) — varchar2(30)
  • d_member (d_tel3) — varchar2(30)
  • d_member (d_birth_y) — date
  • d_member (d_birth_m) — date
  • d_member (d_birth_d) — date
  • d_member (d_sl) — char(3)
  • d_member (d_date) — date

고객센터 (공지사항)

  • notice (hNnum) — number — 기본 키 — NOT NULL
  • notice (hNname) — varchar2(20) — 외래 키 → 관리자.admin — NOT NULL
  • notice (hNtitle) — varchar2(100)
  • notice (hNcontent) — varchar2(1000)
  • notice (hNday) — date
  • notice (hNhit) — number

고객센터 (1:1문의)

  • inquiry (hInum) — number — 기본 키 — NOT NULL
  • inquiry (hIname) — varchar2(20) — 외래 키 → MEMBERSHIP.d_member — NOT NULL
  • inquiry (hIstep) — varchar2(1000) — 외래 키 → 관리자.admin — NOT NULL
  • inquiry (hItitle) — varchar2(100)
  • inquiry (hIcontent) — varchar2(1000)
  • inquiry (hIfile) — varchar2(100)
  • inquiry (hIday) — date

고객센터 (FAQ)

  • FAQ (hFnum) — number — 기본 키 — NOT NULL
  • FAQ (hFname) — varchar2(20) — 외래 키 → 관리자.admin — NOT NULL
  • FAQ (hFtitle) — varchar2(1000)
  • FAQ (hFcontent) — varchar2(1000)

관리자 (Untitled)

  • admin — varchar2(20) — 기본 키 — NOT NULL

커뮤니티 (사용후기)

  • community_board (c_number) — number — 기본 키 — NOT NULL
  • community_board (c_user) — varchar2(20) — 외래 키 → MEMBERSHIP.d_member — NOT NULL
  • community_board (c_product) — varchar2(70)
  • community_board (c_title) — varchar2(100)
  • community_board (c_grade) — varchar2(20)
  • community_board (c_date) — date
  • community_board (c_hits) — number
  • community_board (c_content) — varchar2(1000)
  • community_board (c_category1) — varchar2(40)
  • community_board (c_category2) — varchar2(40)
  • community_board (c_purchase) — varchar2(40)
  • community_board (c_file) — varchar2(100)

커뮤니티 (체험단)

  • community_admin_experience (ca_number) — number — 기본 키 — NOT NULL
  • community_admin_experience (ca_admin) — varchar2(20) — 외래 키 → 관리자.admin — NOT NULL
  • community_admin_experience (ca_title) — varchar2(100)
  • community_admin_experience (ca_grade) — varchar2(100)
  • community_admin_experience (ca_recruiting) — varchar2(40)
  • community_admin_experience (ca_apply_period1) — date
  • community_admin_experience (ca_apply_period2) — date
  • community_admin_experience (ca_review_period1) — date
  • community_admin_experience (ca_review_period2) — date
  • community_admin_experience (ca_release_date) — date
  • community_admin_experience (ca_content) — varchar2(1000)
  • community_admin_experience (ca_file) — varchar2(70)

커뮤니티 (EnjoyCoffe)

  • community_enjoy (ce_number) — number — 기본 키 — NOT NULL
  • community_enjoy (ce_admin) — varchar2(20) — 외래 키 → 관리자.admin — NOT NULL
  • community_enjoy (ce_title) — varchar2(100)
  • community_enjoy (ce_content) — varchar2(1000)
  • community_enjoy (ce_write_day) — date
  • community_enjoy (ce_hits) — varchar2(100)
  • community_enjoy (ce_file1) — varchar2(70)
  • community_enjoy (ce_file2) — varchar2(70)

커뮤니티 (체험단 신청)

  • community_experience_apply (cea_number) — number — 외래 키 → 커뮤니티.community_admin_experience — NOT NULL
  • community_experience_apply (cea_user) — varchar2(20) — 외래 키 → MEMBERSHIP.d_member — NOT NULL
  • community_experience_apply (cea_title) — varchar2(400)
  • community_experience_apply (cea_content) — varchar2(1000)

커뮤니티 (체험단 리뷰)

  • community_experience_review (cear_number) — number — 외래 키 → 커뮤니티.community_admin_experience — NOT NULL
  • community_experience_review (cear_user) — varchar2(20) — 외래 키 → MEMBERSHIP.d_member — NOT NULL
  • community_experience_review (cear_title) — varchar2(500)
  • community_experience_review (cear_content) — varchar2(1000)
  • community_experience_review (cear_hits) — varchar2(60)
  • community_experience_review (cear_write_day) — date
  • community_experience_review (cear_grade) — varchar2(50)
  • community_experience_review (cear_file) — varchar2(70)