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