kb2팀

테이블 (4)

Authority (Untitled4)

  • user_id (Key) — number(10) — 외래 키 → Untitled.user_id — NOT NULL
  • Field

Board (Untitled5)

  • user_id (PK) — number(10) — 외래 키 → Untitled.user_id — NOT NULL
  • board_id (Field2) — varchar2(20)
  • board_pwd (Field3) — varchar2(20)
  • board_date (Field4) — date
  • board_detail (Field5) — varchar2(100)
  • product_id (FK)

Comment (Untitled3)

  • comment_id (PK) — number(10) — 기본 키 — NOT NULL
  • user_id (FK) — varchar2(20) — 외래 키 → Untitled.user_id — NOT NULL
  • product_id (Field) — varchar2(20)
  • board_id (Field2) — varchar2(20)
  • comment_pwd (Field4) — varchar2(20)
  • comment_detail (Field5) — varchar2(100)
  • comment_date (Field6) — date

Untitled

  • user_id (PK) — number(10) — 기본 키 — NOT NULL
  • enum (Field) — varchar2(1)
  • name (Field2) — varchar2(20)
  • age (Field3) — number(3)
  • gender (Field4)
  • phone (Field6) — varchar2(20)
  • addr (Field7) — varchar2(50)
  • detail (Field8) — varchar2(100)
  • email (Field5) — varchar2(50)
  • password (Field10) — varchar2(20)
  • preference (Field9)