kh15 세미플젝

테이블 (8)

attachment

  • attachment_no — number — 기본 키 — NOT NULL
  • attachment_name — varchar2(255)
  • attachment_type — varchar2(255)
  • attachment_size — number

board_like

  • member_id — varchar2(20) — NOT NULL
  • board_no — number — NOT NULL

giftcard

  • giftcard_no — number — 기본 키 — NOT NULL
  • giftcard_name — varchar2(90)
  • giftcard_content — varchar2(1000)
  • giftcard_charge — number
  • giftcard_price — number

giftcard_image

  • giftcard_no — number — NOT NULL
  • attachment_no — number — NOT NULL

giftcard_purchase

  • giftcard_purchase_no — number — 기본 키 — NOT NULL
  • giftcard_purchase_target — number — NOT NULL
  • giftcard_purchase_member — varchar2(20) — NOT NULL
  • giftcard_purchase_qty — number
  • giftcard_purchase_time — timestamp

리뷰 (review)

  • reply_no — number — 기본 키 — NOT NULL — 시퀀스로 설정
  • reply_content — varchar(1500) — NOT NULL
  • reply_wtime — timestamp — NOT NULL
  • reply_etime — timestamp
  • review_writer — varchar2(20) — 외래 키 → 회원.member_id — NOT NULL
  • review_origin (review_orgin) — number — 외래 키 → 회사.board_no — NOT NULL

회사 (company)

  • board_no — number — 기본 키 — NOT NULL
  • board_title — varchar2(300)
  • board_content — varchar2(3000)
  • member_id — varchar2(20) — NOT NULL
  • board_wtime — timestamp
  • board_etime — timestamp
  • board_like — number
  • board_read — number
  • board_reply — number
  • board_group — number
  • board_target — number — NOT NULL
  • board_depth — number

회원 (member)

  • member_id — varchar2(20) — 기본 키 — NOT NULL
  • member_pw — varchar2(16)
  • member_nickname — varchar2(30)
  • member_birth — char(10)
  • member_contact — char(11)
  • member_email — varchar2(60)
  • member_level — varchar2(12)
  • member_point — number
  • member_post — varchar2(6)
  • member_address1 — varchar2(300)
  • member_address2 — varchar2(300)
  • member_join — timestamp
  • member_login — timestamp
  • member_change — timestamp