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)