myproject

Tables (9)

article

  • id (Key) — INT — Primary key — NOT NULL
  • title (Field) — VARCHAR
  • body (Field2) — TEXT
  • memberId (Key3) — INT — Foreign key → member.id — NOT NULL
  • boardId (Key2) — INT — Foreign key → board.id — NOT NULL
  • hitcount (Field5) — INT
  • ReactionPoint (Field6) — INT
  • regDate (Field8) — DATETIME
  • updateDate (Field9) — DATETIME

board

  • id (Key) — INT — Primary key — NOT NULL
  • code (Field) — VARCHAR
  • name (Field2) — VARCHAR
  • regDate (Field3) — DATETIME
  • updateDate (Field4) — DATETIME
  • delStatus (Field5) — TINYINT
  • delDate (Field6) — DATETIME

comment

  • id (Key) — INT — Primary key — NOT NULL
  • relId (Key2) — INT — Foreign key → article.id — NOT NULL
  • memberId (Key3) — Foreign key → member.id — NOT NULL
  • comment (Field)
  • ReactionPoint (Field3)
  • relTypeCode (Field4)
  • regDate (Field6)
  • updateDate (Field7)

member

  • id (Key) — Primary key — NOT NULL
  • loginId (Field)
  • loginPw (Field2)
  • mname (Field4)
  • cellphoneNum (Field5)
  • authLevel (Field9)
  • regDate (Field14)
  • updateDate (Field15)
  • delStatus (Field16)
  • delDate (Field17)

membership

  • id (Key) — Primary key — NOT NULL
  • loginId (Field2)
  • authLevel (Field)
  • type (Field4)
  • membercode (Key2) — Foreign key → member.id — NOT NULL
  • regDate (Field6)
  • updateDate (Field7)
  • endStatus (Field8)
  • endDate (Field9)

player

  • id (Key) — Primary key — NOT NULL
  • pname (Field)
  • position (Field2)
  • number (Field3)
  • startDate (Field4)
  • endDate (Field5)
  • image (Field6)
  • regDate (Field7)
  • updateDate (Field8)

reactionPoint

  • id (Key) — INT — Primary key — NOT NULL
  • relId (Key3) — INT — Foreign key → article.id — NOT NULL
  • memberId (Key2) — INT — Foreign key → member.id — NOT NULL
  • relTypeCode (Field2) — VARCHAR
  • point (Field4) — INT
  • regDate (Field5) — DATETIME
  • updateDate (Field6) — DATETIME

schedule

  • Key — Primary key — NOT NULL
  • id (Field)
  • date (Field2)
  • num (Field3)
  • stype (Field4)
  • time (Field5)
  • stadium (Field6)
  • broadcasting (Field7)
  • round (Field8)
  • info (Field9)
  • game (Field10)

team

  • id (Key) — Primary key — NOT NULL
  • tname (Field)
  • stadium (Field2)
  • address (Field3)
  • timg (Field4)
  • latitude (Field5)
  • longitude (Field6)
  • regDate (Field7)
  • updateDate (Field8)