untitled

Tables (10)

Untitled (Member)

  • Key (mem_id) — INT — Primary key — NOT NULL
  • Field (mem_userid) — VARCHAR(50) — NOT NULL
  • Field (mem_pw) — PASSWORD — NOT NULL
  • Field (mem_nick) — VARCHAR(50) — NOT NULL
  • Field (mem_birth) — DATE
  • Field (mem_email) — VARCHAR(100)
  • Field (mem_phone) — VARCHAR(13)
  • Field (mem_major) — VARCHAR(50)
  • Field (mem_profile_content) — TEXT
  • Field (mem_photo) — VARCHAR(255)
  • Field (mem_write) — INT
  • Field (mem_reply) — INT
  • Field (mem_answer) — INT
  • Field (mem_creative) — INT
  • Field (mem_leaderC) — INT
  • Field (mem_pro) — INT
  • Field (mem_team) — INT
  • Field (mem_giturl) — VARCHAR(255)
  • Field (mem_blogurl) — VARCHAR(255)
  • Field (mem_grade) — VARCHAR(5)

Untitled (Alarm)

  • Key (alm_id) — INT — Primary key — NOT NULL
  • Field (mem_id) — INT — NOT NULL — Foreign Key
  • Field (target_mem_id) — INT
  • Field (alm_content_id) — INT
  • Field (alm_message) — TEXT
  • Field (alm_url) — VARCHAR(255)
  • Field (alm_datetime) — DATETIME
  • Field (alm_read_datetime) — DATETIME

Untitled (Hashtag)

  • Key (hash_id) — INT — Primary key — NOT NULL
  • Field (prj_id) — INT — Hashtag가 속해있는 project의 id
  • Field (hash_name) — VARCHAR(50)

Untitled (Project)

  • Key (prj_id) — INT — Primary key — NOT NULL
  • Field (mem_id) — INT — NOT NULL — 프로젝트를 만든 사람의 id
  • Field (fellow_mem_id) — INT — 프로젝트에 속해 있는 사용자의 id들
  • Field (prj_category) — VARCHAR(50)
  • Field (prj_name) — VARCHAR(50)
  • Field (prj_abstract) — TEXT
  • Field (prj_intro) — TEXT
  • Field (prj_period) — DATE
  • Field (prj_image) — VARCHAR(255)
  • Field (board_id) — INT
  • Field (prj_cate_id) — INT
  • Field (cate_id) — INT

Untitled (Project_Category)

  • Key (cate_id) — INT — Primary key — NOT NULL
  • Field (board_id) — INT — NOT NULL — 카테고리를 포함하고 있는 게시판 id
  • Field (cate_name) — VARCHAR(50)
  • Field (cate_num) — INT — NOT NULL — 카테고리에 속하는 타임라인의 개수

Untitled (Category(39))

    Untitled (Board)

      Untitled (Reply)

      • Key (re_id) — INT — Primary key — NOT NULL
      • Field (mem_id) — INT
      • Field (board_id) — INT
      • Field (re_content) — TEXT

      Untitled (Fellow)

      • Key (fell_id) — INT — Primary key — NOT NULL
      • Field (mem_id) — INT
      • Field (prj_id) — INT

      Untitled (Feedback)