mini

Tables (5)

Applicant (Untitled5)

  • BoardId (Key2) — NUMBER — Foreign key → Board.BoardId — NOT NULL
  • MemberId (Key3) — NUMBER — Foreign key → Member.MemberId — NOT NULL
  • createdAt (Field) — Date

Board (Untitled2)

  • BoardId (Key2) — NUMBER — Primary key — NOT NULL
  • MemberId (Key) — NUMBER — Foreign key → Member.MemberId — NOT NULL
  • type — VARCHAR — NOT NULL
  • title — VARCHAR
  • contents — VARCHAR
  • memberNum — VARCHAR
  • date — Date — NOT NULL
  • createdAt — Date
  • modifiedAt — Date

Comment (Untitled3)

  • CommentId (Key3) — NUMBER — Primary key — NOT NULL
  • BoardId (Key2) — NUMBER — Foreign key → Board.BoardId — NOT NULL
  • MemberId (Key) — NUMBER — Foreign key → Member.MemberId — NOT NULL
  • contents — VARCHAR
  • createdAt — Date
  • modifiedAt — Date

Member (Untitled)

  • MemberId (Key) — NUMBER — Primary key — NOT NULL
  • loginId — VARCHAR — NOT NULL
  • nickname (Field2) — VARCHAR — NOT NULL
  • password (Field3) — VARCHAR — NOT NULL

TIMESTAMPED (Untitled4)

  • createdAt — Date
  • modifiedAt — Date