Test

Tables (6)

Board (Guest Board)

  • BoardNumber (number) — int(10) — Primary key — NOT NULL
  • Id (id) — varchar2(20) — Foreign key → Member.Id — NOT NULL
  • Title (title) — varchar2(50)
  • Content (content) — text
  • Date (date) — date
  • GuestInfo (guestInfo) — varchar2(100)

Board (Admin Board)

  • Title (title) — varchar2(50) — Primary key — NOT NULL
  • BigSubject (bigSubject) — varchar2(100)
  • SmallSubject (smallSubject) — varchar2(100)
  • Content (content) — text

Board (Admin Content Board)

  • Title (title) — varchar2(50) — Foreign key → Board.Title — NOT NULL
  • BigSubject (bigSubject) — varchar2(100)
  • SmallSubject (smallSubject) — varchar2(100)
  • Content (content) — text

Member (Member Info)

  • Id (id) — varchar2(20) — Primary key — NOT NULL
  • Password (pw) — varchar2(15)
  • Adress (adress) — varchar2(100)
  • Email (email) — varchar2(30)
  • Name (name) — varchar2(20)
  • PhoneNumber (phoneNumber) — int(15)

Member (MemberGrade)

  • Number (number) — int(10) — Primary key — NOT NULL
  • Id (id) — varchar2(20) — Foreign key → Member.Id — NOT NULL
  • Grade (grade) — TINYINT(1)

Member (Search Member)

  • Email (email) — varchar2(30) — Primary key — NOT NULL
  • Id (id) — varchar2(20) — Foreign key → Member.Id — NOT NULL