members
Tables (3)
MEMBERS
- MEMBER_ID — NUMBER — Primary key
- NAME — VARCHAR2(100) — NOT NULL
- EMAIL — VARCHAR2(100) — NOT NULL
- PASSWORD — VARCHAR2(100) — NOT NULL
- CREATED_AT — DATE
board
- num — number(5) — Primary key
- memberNo (writer) — number(5) — Foreign key → member.memberNo
- title — varchar2(60)
- content — VARCHAR2(600)
- regtime — varchar2(20)
- hits — NUMBER(10)
member
- memberNo — number(5) — Primary key
- joinDate — date
- name — varchar2(20)
- id — varchar2(20)
- pw — varchar2(20)