Fitness

Tables (16)

Members (회원)

  • userid (Key) — varchar(15) — Primary key — NOT NULL
  • type (Key2) — int — Foreign key → membertype.mtype_code — NOT NULL
  • question (Key3) — int — Foreign key → question.q_code — NOT NULL
  • password (Field) — varchar(20)
  • nickname (Field2) — varchar(20)
  • human_id (Field3) — varchar(14)
  • age (Field4) — int
  • name (Field5) — varchar(20)
  • gender (Field7) — varchar(6)
  • mobile (Field8) — varchar(20)
  • address (Field9) — varchar(300)
  • email (Field10) — varchar(100)
  • answer (Field12) — varchar(300)

Mship (멤버쉽)

  • no (Key) — int — Primary key — NOT NULL
  • code (Key2) — int — Foreign key → Sports.code — NOT NULL
  • month (Field2) — varchar(20)
  • price (Field3) — int
  • M_code (Field4) — int

N_board (공지사항)

  • bno (Key) — int — Primary key — NOT NULL
  • title (Field) — varchar(150)
  • content (Field2) — varchar(2000)
  • writer (Field3) — varchar(50)
  • regdate (Field4) — timestamp
  • updatedate (Field5) — timestamp

QnA_board (커뮤니티)

  • bno (Key) — int — Primary key — NOT NULL
  • title (Field) — varchar(150)
  • content (Field2) — varchar(2000)
  • writer (Field3) — varchar(50)
  • regdate (Field4) — timestamp
  • updatedate (Field5) — timestamp

QnA_reply (커뮤니티 댓글)

  • no (Key) — int — Primary key — NOT NULL
  • bno (Key3) — int — Foreign key → QnA_board.bno — NOT NULL
  • grp (Field2) — int
  • grps (Field3) — int
  • grpl (Field4) — int
  • writer (Key2) — varchar(15) — Foreign key → Members.userid — NOT NULL
  • content (Field6) — varchar(1000)
  • wdate (Field7) — datetime

Sports (스포츠)

  • code (Key) — int — Primary key — NOT NULL
  • sports_name (Field) — varchar(20)

board (게시판)

  • bno (Key) — int — Primary key — NOT NULL
  • title (Field) — varchar(150)
  • content (Field2) — varchar(2000)
  • writer (Field3) — varchar(50)
  • regdate (Field4) — TIMESTAMP
  • updatedate (Field5) — TIMESTAMP

contact (상담)

  • no (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • email (Field2) — varchar(50)
  • mobile (Field3) — varchar(20)
  • message (Field4) — varchar(3000)
  • send_dt (Field5) — DATE

kcal (영양정보)

  • num (Key) — varchar(100) — Primary key — NOT NULL
  • name (Field) — varchar(100)
  • kcal (Field2) — varchar(100)
  • carbohydrate (Field3) — varchar(100)
  • protein (Field4) — varchar(100)
  • fat (Field5) — varchar(100)
  • sugars (Field6) — varchar(100)
  • na (Field7) — varchar(100)
  • cholesterol (Field8) — varchar(100)
  • saturated_fatty_acids (Field9) — varchar(100)
  • transfat (Field10) — varchar(100)

membertype (권한)

  • mtype_code (Key) — int — Primary key — NOT NULL
  • mtype (Field) — varchar(20)

mypage (마이페이지)

  • userid (Key) — varchar(15) — Foreign key → Members.userid — NOT NULL
  • height (Field) — decimal(3,0)
  • weight (Field2) — decimal(3,0)

p_reply (게시판 댓글)

  • no (Key) — int — Primary key — NOT NULL
  • bno (Key3) — int — Foreign key → board.bno — NOT NULL
  • grp (Field) — int
  • grps (Field2) — int
  • grpl (Field3) — int
  • writer (Key2) — varchar(15) — Foreign key → Members.userid — NOT NULL
  • content (Field4) — varchar(1000)
  • wdate (Field5) — DATETIME

question (질문)

  • q_code (Key) — int — Primary key — NOT NULL
  • q_type (Field) — varchar(100)

refund (Untitled)

  • no_type (Key) — int — Primary key — NOT NULL
  • ref_name (Field) — varchar(10)

ticket (회원권)

  • userid (Key) — varchar(15) — Foreign key → Members.userid — NOT NULL
  • sports_name (Field) — varchar(15)
  • start_dt (Field2) — varchar(20)
  • end_dt (Field3) — varchar(20)
  • refund (Key2) — int — Foreign key → refund.no_type — NOT NULL

video (운동영상)

  • no (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(30)
  • url (Field2) — varchar(5000)