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)