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)