AD

Tables (7)

cartoon (만화)

  • id (Key) — int — Primary key — NOT NULL
  • cartoon_name (웹툰) — varchar(15)
  • category (카테고리) — varchar(20)
  • url (웹툰 url) — varchar(100)
  • img (이미지)

information (유저 정보)

  • id (primary key) — int — Foreign key → user.id — NOT NULL
  • user_id (user(id)) — int
  • liking_id (liking(id)) — int

liking (유저 취향)

  • Field
  • Field2
  • Field3
  • Field4

reply (댓글)

  • writitng_id (글 아이디) — int
  • user_id (유저 아이디) — int

user (회원기본정보)

  • id (primary key) — int — Primary key — NOT NULL
  • user_id (아이디) — varchar(15)
  • password (비밀번호) — varchar(15)
  • name (사용자이름) — varchar(15)
  • gender (성별) — enum()
  • age (나이/ 연령 제한) — int
  • creat _at (생성날짜) — date
  • login (로그인 상태) — varchar(15)
  • nickname (닉네임) — varchar(15)

writer (작가)

  • id (pimary key) — int — Primary key — NOT NULL
  • Field

writing (글작성)

  • id (primary key) — int — Primary key — NOT NULL
  • user_id (글쓴 유저 아이디) — int
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Field7