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