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