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 (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