SportsCenter

Tables (6)

ROLE (TB_ROLE)

  • ROLE_ID (Key) — Primary key — NOT NULL
  • ROLE_NAME (Field)

USER (TB_USER)

  • USER_NO (Key) — Primary key — NOT NULL
  • USER_ID (Field)
  • USER_NAME (Field2)
  • PASSWORD (Field3)

USER_ROLE (TB_USER_ROLE)

  • USER_NO (Key) — Foreign key → USER.USER_NO — NOT NULL
  • ROLE_ID (Key2) — Foreign key → ROLE.ROLE_ID — NOT NULL

addMember (tb_addMember)

  • notice_no (Key) — auto_increment — Primary key — NOT NULL
  • name (Field) — varchar(50)
  • tel (Field2) — varchar(50)
  • gender (Field3) — varchar(50)
  • id (Field4) — varchar(50)
  • pwd (Field5) — varchar(100)
  • date (Field6) — timestamp

notice (TB_NOTICE)

  • NOTICE_NO (Key) — Primary key — NOT NULL
  • USER_NO (Key2) — Foreign key → USER.USER_NO — NOT NULL
  • title (Field2)
  • contents (Field3)
  • reg_date (Field4)
  • Field

notice (tb_notice)

  • notice_no (Key) — auto_increnment — Primary key — NOT NULL
  • title (Field) — varchar(150)
  • content (Field2) — varchar(2000)
  • writer (Field3) — varchar(50)
  • date (Field4) — timestamp
  • updatedate (Field5) — timestamp