홍대의_물리

테이블 (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