웹개발
테이블 (6)
activity (Untitled3)
- activity_num — int — 기본 키 — NOT NULL
- club_num — int — 외래 키 → club.club_num — NOT NULL
- arctivity_name (activity_name) — varchar(50)
- location — int
- activity_field — int
- content — long
- create_date — sysdate
- update_date — sysdate
activity_file (Untitled6)
- file_num — int — 기본 키 — NOT NULL
- activity_num — int — 외래 키 → activity.activity_num — NOT NULL
- club_num — int — 외래 키 → activity.club_num — NOT NULL
- path — path
- file_name — varchar(1000)
- created_date — sysdate
- updated_date — sysdate
club (Untitled2)
- club_num — int — 기본 키 — NOT NULL
- member_id — varchar(50) — 외래 키 → user.memberId — NOT NULL
- clubName — varchar(100)
- location — int
- clubField(분야) (clubField) — int
- content — long
- path
- create_date — sysdate
- update_date — sysdate
post (Untitled4)
- PostNum — int — 기본 키 — NOT NULL
- memberId — varchar(50) — 외래 키 → user.memberId — NOT NULL
- title — varchar(100)
- content — long
- create_date — sysdate
- update_date — sysdate
user (Untitled)
- memberId — varchar(50) — 기본 키
- password — varchar(20)
- name — varchar(10)
- email — varchar(100)
- joinClub — varchar(100)
- joinActivity — varchar(100)
- wantClub — varchar(100)
volunteer (Untitled5)
- member_num — int — 기본 키 — NOT NULL
- club_num — int — 외래 키 → club.club_num — NOT NULL
- memberId — varchar(50) — 외래 키 → user.memberId