홍대의_물리
테이블 (5)
board (Untitled2)
- board_no (Key) — NUMBER — 기본 키 — NOT NULL
- userid (key) — VARCHAR2 — 외래 키 → member.userid — NOT NULL
- board_title (Field) — VARCHAR2
- board_content (Field2) — VARCHAR2
- userid (Field3) — VARCHAR2
- board_cdate (Field4) — TIMESTAMP
- reply_count (Field5) — NUMBER
cart (Untitled5)
- 장바구니번호 (Key) — NUMBER — 기본 키 — NOT NULL
- 회원아이디 (key) — VARCHAR2 — 외래 키 → member.userid — NOT NULL
- 상품번호 (Field2) — NUMBER
- 상품개수 (Field3) — NUMBER
member (Untitled)
- userid (key) — VARCHAR2 — 기본 키 — NOT NULL
- password (Field) — VARCHAR2
- username (Field2) — VARCHAR2
- nickname (Field3) — VARCHAR2
- gender (Field4) — VARCHAR2
- age (Field5) — NUMBER
- skin_type (Field6) — VARCHAR2
- skin_trouble (Field7) — VARCHAR2
- email (Field8) — VARCHAR2
- phone (Field9) — VARCHAR2
- address (Field10) — VARCHAR2
- mdate (Field11) — DATE
product (Untitled4)
- product_no (Key) — NUMBER — 기본 키 — NOT NULL
- 장바구니번호 (Key2) — NUMBER — 외래 키 → cart.장바구니번호 — NOT NULL
- 회원아이디 (key) — VARCHAR2 — 외래 키 → cart.회원아이디 — NOT NULL
- product_name (Field) — VARCHAR2
- price (Field2) — NUMBER
- point (Field3) — VARCHAR2
- grade (Field4) — NUMBER
- good (Field5) — NUMBER
reply (Untitled3)
- reply_no (Key) — NUMBER — 기본 키 — NOT NULL
- reply_bno (Key2) — NUMBER — 외래 키 → board.board_no — NOT NULL
- userid (key) — VARCHAR2 — 외래 키 → board.userid — NOT NULL
- reply_content (Field) — NUMBER
- reply_adminid (Field2) — VARCHAR2
- reply_cdate (Field3) — VARCHAR2