MyProject3

Tables (5)

authority (Untitled3)

  • 아이디 (username) — VARCHAR2(20) — Foreign key → projectmember.아이디 — NOT NULL
  • Field (authority) — VARCHAR2(20)

board (Untitled5)

  • 번호 (no) — NUMBER — Primary key — NOT NULL
  • 아이디 (id) — VARCHAR2(20) — Foreign key → projectmember.아이디 — NOT NULL
  • 제목 (title) — VARCHAR2(200) — NOT NULL
  • 내용 (content) — CLOB — NOT NULL
  • 종류 (category) — VARCHAR2(50) — NOT NULL
  • 작성일 (regdate) — DATE

persistent_logins (Untitled2)

  • 아이디 (username) — VARCHAR2(20)
  • Field (series) — VARCHAR2(64)
  • Field (token) — VARCHAR2(64)
  • Field (last_used) — TIMESTAMP

projectmember (Untitled)

  • 아이디 (id) — VARCHAR2(20) — Primary key — NOT NULL
  • 이름 (name) — VARCHAR2(51) — NOT NULL
  • 비밀번호 (pwd) — VARCHAR2(100) — NOT NULL
  • Field (enable) — NUMBER(1)
  • 성별 (sex) — CHAR(6)
  • 생일 (birthday) — VARCHAR2(20) — NOT NULL
  • 이메일 (email) — VARCHAR2(100) — NOT NULL
  • 우편번호 (post) — VARCHAR2(10) — NOT NULL
  • 주소 (addr1) — VARCHAR2(500) — NOT NULL
  • 상세주소 (addr2) — VARCHAR2(100) — NOT NULL
  • 전화번호 (phone) — VARCHAR2(20) — NOT NULL
  • 소개 (content) — CLOB
  • Field (regdate) — DATE
  • Field (modifydate) — DATE
  • Field (lastlogin) — DATE
  • fname — VARCHAR2(51)
  • 이름 (sname) — VARCHAR2(51)
  • point — NUMBER
  • state — CHAR(1)

study (Untitled4)

  • 스터디그룹 아이디 (no) — NUMBER — Primary key — NOT NULL
  • 아이디 (id) — VARCHAR2(20) — Foreign key → projectmember.아이디 — NOT NULL
  • 그룹명 (title) — VARCHAR2(200) — NOT NULL
  • 최대인원 (max_participants) — NUMBER — NOT NULL
  • 현재인원 (current_participants) — NUMBER — NOT NULL
  • 마감일 (deadline) — Date
  • 상태(모집중,마감) (status) — NUMBER(1)
  • 생성일 (created_at) — DATE