swime
Tables (14)
category (Untitled12)
- category_id (카테고리번호) — int — Primary key — NOT NULL
- title (카테고리이름) — varchar
- Field2
code table (Untitled8)
- Key — Primary key — NOT NULL
group (Untitled2)
- group_id (그룹id) — int — Primary key — NOT NULL
- group_name (그룹이름) — varchar
- group_region (그룹지역) — varchar
- group_language (그룹관련언어) — varchar
- short_introducing (짧은소개) — varchar
- admin (그룹장) — varchar
group list (Untitled9)
- group_id (그룹이름) — int — Primary key — NOT NULL
- group_entry (그룹참여자) — varchar
- group_admin (그룹장) — varchar
- Field
group_specific (Untitled3)
- group_id (그룹id) — int — Primary key — NOT NULL
- group_info (그룹상세설명) — varchar
- group_photo (그룹참여사진) — varchar
- group_study (그룹스터디) — varchar
mail (Untitled)
- user_id (유저아이디) — varchar — Primary key — NOT NULL
- sender (보낸사람) — varchar
- receiver (받은사람) — varchar
- rec_time (받은시간)
- send_time (보낸시간)
- content (내용) — varchar
market_board (Untitled11)
- board_id (게시판번호) — int — Primary key — NOT NULL
- product_id (게시물번호) — int
- category_id (카테고리번호) — int
- Field4
payinfo (Untitled7)
- id (유저아이디) — int — Primary key — NOT NULL
- price (결제금액) — int
- trans_time (결제시간) — varchar
- trans_no (결제번호) — varchar
- refund_acco (환불계좌) — int
- Field
product (Untitled13)
- product_id (상품번호) — int — Primary key — NOT NULL
- user_id (유저id) — varchar
- product_title (게시물이름)
- Field3
- Field4
score (Untitled6)
- id (유져id) — varchar — Primary key — NOT NULL
- score (발열량점수) — int
study (Untitled4)
- study_id (스터디id) — int — Primary key — NOT NULL
- start_time (시작시간) — date
- end_time (끝시간) — date
- study_title (스터디주제) — varchar
- study_info (스터디내용) — varchar
- study_deposit (보증금) — int
- study_people (스터디인원수) — int
- location (스터디장소) — varchar
- study_pic (스터디사진) — varchar
- study_stat (스터디상태)
study review (Untitled10)
- study_id (스터디id) — int — Primary key — NOT NULL
- study_review (스터디리뷰) — varchar
- study_picture (스터디사진) — varchar
- Field
table name (Untitled5)
- study_id (스터디id) — int — Primary key — NOT NULL
- study_parti (스터디참여자) — varchar
- parti_stat (참여상태) — varchar
user
- user_id (유저아이디) — varchar — Primary key — NOT NULL
- user_mail (유저메일) — varchar
- user_region (유저지역) — varchar
- user_language (유저관심언어) — varchar
- user_myself (유저본인소개) — varchar
- power (발열량) — int