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)