웹개발

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